Discussion Board for collaboration related to QlikView App Development.
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.
You can make a Key column based on multiple columns to compare.
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.