Discussion board where members can get started with QlikView.
I have below script it work fine :-
(A) load the raw data (A) for email :-EMAILADVANCED REMANUFACTUTDS TECHNOLOGY S PTE LTD
Directory;LOAD'ZOHO' AS SOURCE,EMAILFROMZOHO.csv(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
(B) Partial reload to rename EMAIL field
sales_G:LOAD *,EMAIL as KeyAcc_CoyNameresident ZOHO;
(C) load the raw data (B) for email :-EMAILADVANCED REMANUFACTU
Directory;LOAD'TIGER' AS SOURCE,EMAILFROMTIGER.csv(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
(D) Need to Flag coy = ADVANCED REMANUFACTU , since this coy appear at Tiger Table.
sales_G:LOAD *,IF(EXISTS(KeyAcc_CoyName,EMAIL), 'N', 'Y') as flag_key_accresident ZOHO;
I get the Table below , my wish is first row of field flag_key_acc should be display Y instead of N :-
Hope some one can advise me where go wrong ?
Did you try creating a RANK for each row in the Load Script. and then make the values where rank is 1 as 'Y'