Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below script it work fine :-
(A) load the raw data (A) for email :-
EMAIL
ADVANCED REMANUFACTU
TDS TECHNOLOGY S PTE LTD
Directory;
LOAD
'ZOHO' AS SOURCE,
EMAIL
FROM
ZOHO.csv
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
(B) Partial reload to rename EMAIL field
sales_G:
LOAD *,
EMAIL as KeyAcc_CoyName
resident ZOHO;
(C) load the raw data (B) for email :-
EMAIL
ADVANCED REMANUFACTU
Directory;
LOAD
'TIGER' AS SOURCE,
EMAIL
FROM
TIGER.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_acc
resident 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 ?
Paul Yeo
Did you try creating a RANK for each row in the Load Script. and then make the values where rank is 1 as 'Y'