Please help with the script

[ashmitp869]

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.

[Bill_Britt]

Hi,

Would you not use a Where clause to do this?

Bill

[MarcoWedel · Accepted solution]

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]);

[ashmitp869]

Hi Marco,

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

[ashmitp869]

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