topic Merge 2 tables in QlikView

Merge 2 tables

sylvain_piccarreta — Sat, 16 Nov 2024 17:30:45 GMT

Hi,

I search to merge 2 tables.

Table 1

A | B

1 | France

2 | USA

3 | China

table 2

A | B

1 | Europe

I want to create a new table merged like it (value table 2 change the value in table 1 for ID 1)

New table

1 | Europe

2 | USA

3 | China

Thanks for your help,

MayilVahanan — Mon, 08 Feb 2021 09:55:08 GMT

Try with mapping and applymap concept

MapTable1:
Mapping
Load * Inline
[
A | B

1 | Europe
](delimiter is '|');

Table1:
Load A, ApplyMap('MapTable1', A, B) as B Inline
[
A | B

1 | France

2 | USA

3 | China
](delimiter is '|');

sylvain_piccarreta — Thu, 11 Feb 2021 13:16:33 GMT

thanks, but in my case, it doesn't work.

I find a solution. I create a temp tabble to collect in it with join

temptable:

load A, B as B1 from table1;

join

load A, B as Bé from table2

After, I do :

Load A,

for B, I add an IF to detect if Bé is null to take B1 even B2.