Skip to main content
Solved

Assign values to table based on values from another table

  • July 17, 2019
  • 2 replies
  • 21 views
K

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • 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.

K
  • kostass
  • Author
  • 2 replies
  • 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.

 

Community Stats

32,080
Posts
121,818
Replies
39,714
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.