Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

Help need when concatenating two tables with flags

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-

ashmitp869_0-1655422500405.png

 

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

ashmitp869_1-1655422567054.png

 

Labels (1)
0 Replies