Compare columns from multiple sources and replacing null fields

Question

Hello Team,

My aim is to compare two sources and given priority to source1. Wherever the data in source 1 is null then we need to bring data from source2. Here the catch is we have duplicate IDs in same source which reduces the count as it groups the data when doing cross tab while comparing the 2 sources. I have attached the excel which highlights the 2 sources and the expected output.

New Microsoft Excel Worksheet.xlsx

apathetichell · Answer

this is what I'd try.

choosemax.yxzp

jeet_shah94 · Answer

No the nth entry don't match between sources and if we join on ID column it creates duplicate rows as it is one to many or many to many rows joined. Thus need a solution to tackle this.

apathetichell · Answer

is your nth entry in id - always supposed to cross match to the nth entry in id? If not - how do you know which 123 to join against cross table?