Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
pradeepm
Contributor II
Contributor II

How to compare multiple columns from 2 tables

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 Replies
Not applicable

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
MVP
MVP

PFA