topic Re: How to compare multiple columns from 2 tables in QlikView

How to compare multiple columns from 2 tables

Anonymous — Wed, 08 Oct 2014 05:42:31 GMT

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.

Re: How to compare multiple columns from 2 tables

Wed, 08 Oct 2014 05:51:55 GMT

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

Re: How to compare multiple columns from 2 tables

tresB — Wed, 08 Oct 2014 05:57:33 GMT

PFA