Hello.
I have 2 paths that i joined based on a concatenated column…how do i run a match in the join tool and have it produce an email output of non matching items from one of the 2 files.
1 of the files is like a data warehouse and the orher file changes daily and is small and i need to validate the small file against the warehouse fike to see what is and isn’t included.
Solved! Go to Solution.
@Dittau ,
I suppose this is what you want to do.
DWH has numbers from 1-30.
Daily data has numbers of 10, 20, ... 50.
You can use Join tool to tell if the key matches or not.
Matched records go to J output, and unmatched records go to R output.
You can add the result by Formula tool and then Union the record.
I hope this matches with your case.
Workflow
Output
Very helpful!
what determines where the matches go and where the unmatched go in the output from the join tool..the join tool has 3 outputs so what dictates each letter…etc
The meaning of each output is:
L: Left
J: Join
R: Right
This interactive lesson and Tool Mastery article may help.
https://community.alteryx.com/t5/Interactive-Lessons/Joining-Data/ta-p/76634
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Join/ta-p/29814