Join Output

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.

Developer Tools

Accepted answers

Yoshiro_Fujimori

@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

Included.yxmd

All comments

Yoshiro_Fujimori

@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

Included.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703