Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

Issue with Flag

HI ,

I have requirement to create a table from data coming from  two source files with additional column as flag.

sheet 1 of excel document has data coming from one source .

sheet 2 has data coming from another source

sheet 3 is the output table i want to create after comparing first two sheets .

i did tried my best  but facing two problems

1)  flag value are not being displayed properly

2)  while creating output table my resident load fail...

pls help

5 Replies
sunny_talwar

Try this:

cust:

LOAD distinct Customer, 

  If(Len(Trim(Customer)) = 0, Null(), 0) as PayerFlag

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Join(cust)

LOAD Cust as Customer

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);

Test1:

NoConcatenate

LOAD Customer,

  If(IsNull(PayerFlag), 1, PayerFlag) as PayerFlag

Resident cust;

DROP Table cust;

Output:

Capture.PNG

arusanah
Creator II
Creator II
Author

Thank you so much Sunindia !!! works for me  

qlikviewwizard
Master II
Master II

Hi arusanah,

Please mark as Answered to close the thread.

arusanah
Creator II
Creator II
Author

i would have loved to close this issue but im still struggling with it ! sunindia's replay was close enough but not what i exactly want !

sunny_talwar

So then what exactly are you looking to do???