Hi All, I'm trying to join two tables (entity and amount - common field) but getting the message below.
I hope someone can help. Data files and the workflow attached.
Solved! Go to Solution.
@Taxguy03 - join the two datasets just on Entity column.
Looks like not all entities are present in both datasets. In cases like these (un-joined records), you will find them in the L and R outputs of the join tool.
The workflow is running as you configured it - essentially, it is looking for the specific combination of entity and amount in each of the files. Anything from the J output would be records that had the same entity-amount combination. Anything in the R output would be records with entity-amount combinations not in the L input file, and the L output would be the opposite. You want to join by ONLY entity in this case. See attached for the workflow.
You'll notice some fall out still. This is because some entities in the L input file were not in the R input file and vice versa.
Thank you, both. I was basically trying to do a V-look-up between the file.
I can now see the anticipated result. And understand the logic behind the updated workflow.
Hope to talk to you all again.