Case 905 How to Flag company appear at Tiger ?

[paulyeo11]

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

[siddheshmane]

Did you try creating a RANK for each row in the Load Script. and then make the values where rank is 1 as 'Y'

[paulyeo11]

Hi Sir

It is possible to share with me , as when I try to implement to my actual data , I notice that I only get 80% right and not sure why ? May be by ranking will be able to help me solve .

Paul