Join Output

[Dittau]

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.

[Yoshiro_Fujimori · Accepted 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

[Dittau]

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

[Yoshiro_Fujimori]

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