Exclusion List should take from Excel for LOAD Script

lakshmanvepuri — Fri, 15 Nov 2024 23:33:00 GMT

Hi All,

This is the code...used in the SCRIPT

INC:
LOAD
CUST_NAME,
POT_VAR,
STEP_ITEM,
DAM_NAME,
CAN_ID,
M_ID,
POL_NAME
FROM
[D:\Users\LL4356\INC.qvd](qvd)
WHERE

MATCH(POT_VAR,'ListShould Take from Excel') AND
NOT MATCH(CUST_NAME,'ListShould Take from Excel') AND
CAN_ID <> 'ListShould Take from Excel' AND
NOT WILDMATCH(POL_NAME,'ListShould Take from Excel');

Exclusion List is not constant and will be controlled by the User.

Please check the Excel and let me know how to use in the LOAD SCRIPT.

Thanks

Vepuri LK

Re: Exclusion List should take from Excel for LOAD Script

MayilVahanan — Fri, 27 Nov 2020 10:12:41 GMT

HI @lakshmanvepuri

Try like below

LOAD chr(39)&Concat(CUST_NAME, chr(39)&','&chr(39))&chr(39) as CustName,
chr(39)&Concat(POT_VAR, chr(39)&','&chr(39))&chr(39) as PotVar,
chr(39)&Concat(CAN_ID, chr(39)&','&chr(39))&chr(39) as CanId,
chr(39)&Concat(POL_NAME, chr(39)&','&chr(39))&chr(39) as PolName
FROM
[D:\Qlik\personnal\List.xlsx]
(ooxml, embedded labels, table is ExclusionList);

Let vCustName = Peek('CustName');
Let vPotVar = Peek('PotVar');
Let vCanId = Peek('CanId');
Let vPolName = Peek('PolName');

Load * from yoursource where MATCH(POT_VAR,$(vPotVar)) AND
NOT MATCH(CUST_NAME,$(vCustName)) AND
CAN_ID <> $(vCanId) AND
NOT WILDMATCH(POL_NAME,$(vPolName));

topic Exclusion List should take from Excel for LOAD Script in QlikView

Exclusion List should take from Excel for LOAD Script

Re: Exclusion List should take from Excel for LOAD Script