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 -