Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a table :
ID , name
1 abc
2 cdb
3 ddd
Other table
ID , name
1 abc
I need to concatenate both table like below
ID , name , flag
1 abc 1
2 cdc 0
3 ddd 0
How should I do that ? Please asssist
One solution is,
map:
Mapping
LOAD ID&Name, 1 As Flag INLINE [
ID, Name
1, abc
];
tab1:
LOAD *, ApplyMap('map',ID&Name,0) As Flag;
LOAD * INLINE [
ID, Name
1, abc
2, cdb
3, ddd
];
Table1:
Load ID,Name
From Table1Source;
Left Join(Table1)
Load ID,Name,1 as flag
From Table2Source;
Refer this blog for more
https://community.qlik.com/t5/QlikView-App-Dev/Understanding-Join-Keep-and-Concatenate/td-p/328379