Concatenate two columns

[#1]

Hello everyone,

I am trying to concatenate two columns to make one..

like

Col1          Col2

a                  b

c                  d

e                  f

I have these two columns and values and i want to concatenate these two column to make one

like

Col1

a

c

e

b

d

f

Pls help...

Thanks in advance...

[jagannalla · Accepted solution]

Hi,

Load Col1 from tab1;

Load Col2 as Col1 from tab1;

Thanks,

Jagan

[jvishnuram]

Hi Shivam,

Try to load each column as separate,

SAMPLE

Load * Inline [

Col1

a

b

c

];

Concatenate (SAMPLE)

Load * Inline [

Col1

d

e

f

];

[#4]

Thans alot

[#5]

Thanks a lot