Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

amruta101
New Contributor

How to asociate 2 tables with different columns

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,

];


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

 

Desired  the output:

attached in the file 

1 Reply
Highlighted
chrismarlow
Valued Contributor

Re: How to asociate 2 tables with different columns

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.