How do I add a field to my workflow which would be a look up to another data source?

ajaygajree

How do I add a field to my workflow which would be a look up to another data source?

I have a workflow with say 50,000 records (lines) and say 10 columns, I wish to add a field from a different source which has one field that matches in the workflow

I want to see an output with 50,000 records and 11 Columns, with the 11th Column populated only if a value exists in the 2nd course.

I have tried a Join with a Union to the Left Join but this is creating a bigger population.

Am I on the right track or is there another better method?

Thanks in Advance

Ajay

DultonM

Hi @ajaygajree,

If I am understanding your situation correctly, it does sound like a basic join/union would be the right thing to do. However, if you are ending up with more than 50,000 records after your join/union, then the field you are joining on is not unique in your data. For example, let's say both sources have a field called "Fruit" that you want to join on. If the first source (coming into the L-input of the join) has only 1 row with "Apple" but the second source (coming into the R-input of the join) has 3 rows with "Apple", your join will return 3 rows when joining these records. In other words, because the join was not 1-to-1, you get additional rows. If necessary, you may need to unique or summarize your data on each side so that your join is 1-to-1 not 1-to-many or many-to-many. If you are still experiencing difficulty, you can attach some sample data and your workflow and the Community can better help you! Good luck!