topic Re: How to asociate 2 tables with different columns in QlikView

How to asociate 2 tables with different columns

amruta101 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I wanted to learn how can i combine just 2 ids of two different having same data.example below;

Table1:
LOAD * INLINE [
column1
1,
2,
3
];

Table2:
LOAD * INLINE [
column2
1,
2,
3
];

Desired the output:

attached in the file

chrismarlow — Wed, 12 Jun 2019 18:50:21 GMT

Hi,

Not sure exactly what you are trying to achieve, but you could use a preceding load to create copies of column1 & column2 with the same name, so;

Table1: Load *, column1 as LINK; LOAD * INLINE [ column1 1, 2, 3 ]; Table2: Load *, column2 as LINK; LOAD * INLINE [ column2 1, 2, 3 ];

Cheers,

Chris.