Skip to main content
Solved

Assign values to table based on values from another table


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

 

Best answer by david_r

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.

View original
Did this help you find an answer to your question?

2 replies

david_r
Celebrity
  • Best Answer
  • July 17, 2019

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.


  • Author
  • July 17, 2019

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.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings