How to asociate 2 tables with different columns

[amruta101]

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]

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.