Combine the two columns into single column.

[Kohli]

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

[sjhussain]

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.

[Kohli]

I have singel table only with two columns.

[sjhussain]

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.

[zebhashmi]

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