topic Re: Help in scripting in App Development

Help in scripting

ashmitp869 — Thu, 16 Jun 2022 00:34:22 GMT

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

Re: Help in scripting

Saravanan_Desingh — Thu, 16 Jun 2022 02:02:01 GMT

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

Re: Help in scripting

vinieme12 — Thu, 16 Jun 2022 05:10:20 GMT

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