LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Wayne Smith

I'm trying to join one field from each of two different data sets where the field names are different but the data represents the same number - "Assignment Number" in one data set is the same as "Work Order ID" in the other data set. I want to join these data sets into one data set using these two fields as a common field key. What node sequence would be required and what method to tell Lavastorm to join two different field names? Thank you. Wayne Smith

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: maria.pislopez

Hello Wayne,

You can use one of the join nodes in the Correlation library to join the two data sets. Most people use the X-Ref node as it will show you the records that match and any that don't. After connecting the node to your data sources, you can right-click in the left input field and select Assignment Number, then remove the default text in the right input key section and select or type Word Order ID.

If you have any more questions, please let us know.

Maria

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Wayne Smith

This worked perfectly. Thank you!