topic Re: Please help with the script in QlikView

Please help with the script

ashmitp869 — Wed, 15 Jun 2022 06:30:40 GMT

Hi there,

I do have the below script

test:
LOAD DISTINCT [Ward/Location],0 as securorgatt resident AH_MDS;
CONCATENATE (test)
LOAD DISTINCT SecuredOrg AS [Ward/Location],
1 as securorgatt
FROM
[$(vL.QVDPathAH)SensitiveClinicSectionAccessMapping.xlsx]
(ooxml, embedded labels, table is Sheet1);

When I have two values i.e 0 and 1 , I only need to pick the row with 1. How do I do in qlikview script.

Re: Please help with the script

Bill_Britt — Wed, 15 Jun 2022 19:01:12 GMT

Hi,

Would you not use a Where clause to do this?

Bill

Re: Please help with the script

MarcoWedel — Wed, 15 Jun 2022 21:38:39 GMT

maybe like this:

test:
LOAD DISTINCT
SecuredOrg AS [Ward/Location],
1 as securorgatt
FROM [$(vL.QVDPathAH)SensitiveClinicSectionAccessMapping.xlsx] (ooxml, embedded labels, table is Sheet1);

CONCATENATE (test)
LOAD [Ward/Location],
0 as securorgatt
RESIDENT AH_MDS
WHERE not Exists([Ward/Location]);

Re: Please help with the script

ashmitp869 — Wed, 15 Jun 2022 23:14:52 GMT

Hi Marco,

why I am only getting the values as 1 , the 0 are not showing correctly. I want both of them .

Re: Please help with the script

ashmitp869 — Wed, 15 Jun 2022 23:28:27 GMT

even in the Data model table , I only have the ones with value 1 but not showing the data with 0.