Join Output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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