Skip to main content

Hello

 

I have two tables below

 

 

 

This was done in excel, in essence, I want to assign the Pos_ID from the first table to the PosKey in the second table depending on the values on the date/time column on both tables.

 

Is there a way to do this in FME?

 

Thank you

 

Would a FeatureMerger with the following configuration cover your use case?

Assuming that the "large" table is routed to the Requestor and the "small" table to the Supplier.


Hi

Thank you for your answer.

It did join the tables but it did not transfer the values but I guess this has to do with the values in my tables not being of the same type.