topic How can I compare two fields of same temp table and flag 1 when match ? in QlikView

How can I compare two fields of same temp table and flag 1 when match ?

ashmitp869 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I got a temp_table

How can I compare deal1 and dealerNU1 and flag 1 when match else 0 in Qlikview script.

Thanks,

jwjackso — Wed, 28 Feb 2018 14:52:33 GMT

See the example below:

TempTable:

Load *,

If(deal1 = dealerNU1,1,0) as Flag;

SQL Select DateJoinKeyPL,

deal1,

dealnm1,

dealerNU1,

dealernameNU1

from tablename;