Help need when concatenating two tables with flags

ashmitp869 — Thu, 16 Jun 2022 23:37:03 GMT

Hi there ,

I have two tables -

The first table has only 7 rows which is assigned with securorgatt as 1 coming from a file. The other table has full set of [Ward/Location] including the 7 of first table.

My requirement , want to add securorgatt as 0 to the rest of [Ward/Location] other than coming from table 1.

My script-

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

Concatenate(WardwithFlag)
Load
[Ward/Location],
[Ward/Location] as SecuredOrgAccessAttribute,
0 as securorgatt
resident AH_MDS
WHERE NOT EXISTS([Ward/Location]);

But its not working -

its coming null from the second table-

As the Data Model has only got the first table , it didn't concatenate -

topic Help need when concatenating two tables with flags in QlikView

Help need when concatenating two tables with flags