Help in scripting

[ashmitp869]

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

[Saravanan_Desingh]

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

[vinieme12]

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