Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
See the example below:
TempTable:
Load *,
If(deal1 = dealerNU1,1,0) as Flag;
SQL Select DateJoinKeyPL,
deal1,
dealnm1,
dealerNU1,
dealernameNU1
from tablename;