Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Case 905 How to Flag company appear at Tiger ?

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 :-

change no to yes final.png


Hope some one can advise me where go wrong ?

Paul Yeo

2 Replies
siddheshmane
Creator
Creator

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
Master
Master
Author

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