How to compare multiple columns from 2 tables

[Anonymous]

Hi,

I have a table and it has 10 fields, out of those i need to compare 2 fields with the same 2 fields from the other table. if both the values matching i need to create one field and it should show 'Yes', if those are not matching it should show 'No'.

Can anyone please help me on this.

[#2]

You can make a Key column based on multiple columns to compare.

LOAD

     Col1 &'-'&Col2 as ColKey

.....

Or you can use AutoHashnumber() function to transform the fields into unique value and then compare them using joins or keep or where exists functions.

Thanks,

Singh

[tresesco]

PFA