Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team, I have 2 Tbales like
Column1, column2
Hari123 , teja954
abcd123 xyz653
mn342 acv 11
And I want output like:
Coloumn
Hari123
abcd123
mn342
teja954
xyz653
acv 11
Hello,
You can use the concatenate function in the script to combine the two tables as you require.
outputtable:
LOAD
Column1 as newcolumn
resident table1
concatenate(outputtable)
Load
column2 as newcolumn
resident table2;
so in the outputtable you will have single column combining the data.
I have singel table only with two columns.
If you have a single table then you would resident the table twice. Is this what you want?
outputtable:
LOAD
Column1 as newcolumn
resident table1
concatenate(outputtable)
Load
column2 as newcolumn
resident table1;
so in the outputtable you will have single column by the name of newcolumn combining the data.
New:
Load
Col1
from table
col2
from table
or maybe this but i think first one will work
New:
Load
Col1
from table
col2 as Col1
from table