Join Issue

Question

Hi Team,

hope you are doing well. I need help.

I have two files and based on the match a new file is created with yes or No.

While doing match those are "No" should also be part of the final output.

Please find attached and let me know how to go about this,

Thanks

Sri

ShankerV · Answer

Hi @sriniprad08

The issue for more records are due to duplication issue.

Can you please use unique tool before joining one dataset 1 and dataset 2 to avoid the duplication post joining.

Many thanks

Shanker V

RobbieA · Answer

Hi @sriniprad08, You can union your unmatched values and use a formula tool to flag them. Here is a solution using your example:

Sriniprad08 solution.yxmd

sriniprad08 · Answer

Hi @ShankerV ,

Thanks . this is what i did. Ideally the 172 observation from file 2 are subset of the file 1. The final out put file after union should be 7549. But its giving me 7655..

this is the issue i am facing.