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

[Indradip22]

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?

[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:

1. Sample data
2. Expected Output
3. 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.

[caltang · Accepted solution]

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-jo...

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

[Indradip22]

Thanks for your work @caltang . Okay I will try and Let you know.

[caltang]

Hi @Indradip22 - did this help?

If it did, kindly mark it as an accepted solution to close the thread. Thanks!