Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
Thank you so much Sunindia !!! works for me
Hi arusanah,
Please mark as Answered to close the thread.
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 !
So then what exactly are you looking to do???