topic Case 892 How to create a flag for company appear at vtiger ? in QlikView

Case 892 How to create a flag for company appear at vtiger ?

paulyeo11 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have 2 key customers list as below :-

VTIGER:
LOAD * INLINE [
COY_NAME,LAST_NAME,Email
ABB,POW,0rts@stee.stengg.com
AAA,RAT,catherine@mattenplant.com.sg

];

May i know how to create a FIELD = flag_key_acc to list COY_NAME = ABB and AAA ?

ZOHO:
LOAD * INLINE [
COY_NAME,LAST_NAME,Email
XYZ,STEVEN,
ACB,
ABC,????,
ABB,MOM,
ABB,POW,0rts@stee.stengg.com
ADD,WEE,0rts@stee.stengg.com
AAA,KIM
AAA,RAT,catherine@mattenplant.com.sg

];

Hope some one can advise me. I don't know how to start.

Paul Yeo

Re: Case 892 How to create a flag for company appear at vtiger ?

Vegar — Mon, 15 Jun 2020 04:30:15 GMT

You could use match () for this.

LOAD

COY_NAME,LAST_NAME,Email,

If(Match(COY_NAME, 'AAA', 'ABB'), 'Y', 'N') as flag_key_acc

FROM Source

Re: Case 892 How to create a flag for company appear at vtiger ?

paulyeo11 — Mon, 15 Jun 2020 04:41:08 GMT

Hi Sir

Thank you for your sharing , my actual list is very long. it is possible to make your script read Table 1 compare Table 2 ?

Paul

Re: Case 892 How to create a flag for company appear at vtiger ?

Vegar — Mon, 15 Jun 2020 08:53:20 GMT

Yes you can use the preloaded list. Try using the Exists() function.

VTIGER:
LOAD
*,
COY_NAME as KeyAcc_CoyName
INLINE [
COY_NAME,LAST_NAME,Email
ABB,POW,0rts@stee.stengg.com
AAA,RAT,catherine@mattenplant.com.sg
];

ZOHO:
LOAD
*,
IF(EXISTS(KeyAcc_CoyName,COY_NAM ), 'Y', 'N') as flag_key_acc
INLINE [
COY_NAME,LAST_NAME,Email
XYZ,STEVEN,
ACB,
ABC,????,
ABB,MOM,
ABB,POW,0rts@stee.stengg.com
ADD,WEE,0rts@stee.stengg.com
AAA,KIM
AAA,RAT,catherine@mattenplant.com.sg
];

DROP FIELD KeyAcc_CoyName;

Re: Case 892 How to create a flag for company appear at vtiger ?

paulyeo11 — Tue, 16 Jun 2020 01:47:11 GMT

Hi Sir

Thank you very much for your help , it work fine.

Paul