Need to find not matched columns after join from two different database

Hi Alteryx Community,

I am stack with a problem. I need to find not matching columns after join.

I have two different datasets with same number of columns and same column names. One dataset has 4500+ rows and another one has 3000+ rows and both of the datasets have 24 columns. I need to find matching rows using some key columns. Using join tool I have done that. But I need to deal with the not match rows and from that not match rows, need to find those columns for which those rows are not matched. Can anyone help me how can I find those columns?

Workflow

Datasets

Join

Accepted answers

caltang

Done! Please try it out and let me know.

Kindly like & mark as accepted solution to close the thread. Thanks!

Best regards,

Cal

P.S: @Qiu solved something similar a long time ago here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/add-field-identifying-which-join-criteria-failed/td-p/777103

Have a read! I used this method based off his work.

For Indradip22.yxzp

All comments

caltang

Hi @Indradip22 - from the information you provided, can't you look at the L and R side of the Join Tool to get the non-joins?

I think it will be more helpful if you can provide us with:

Sample data
Expected Output
Nice-to-haves

Then we can assist better. Otherwise, it may be harder to diagnose.

Indradip22

Hi @caltang

I have attached two files(file1,file2) which will be my demo data. And File1_expected and File2_expected is my expected output. And Key columns are Brand_name, Model_name, RAM, price, processor, rear_Camera and Sim_slot.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703