Append All column in one Column

[#1]

Hi,

I have a one table which is containing 3 fields.I want a column which is containing all records from all Column.

For Example:-

Table1:

Column1 Column2 Column3

1              2           3

3              1           5

6               5          2

result which i want is:

Column

1

3

6

2

1

5

3

5

2

Thanks in advance,Please help me to resolve that issue.

Regards,

Nisha

[marcus_malinow]

Table2:

LOAD Column1 as Column

RESIDENT Table1;

CONCATENATE (Table2)

LOAD Column2 as Column

RESIDENT Table1;

CONCATENATE (Table2)

LOAD Column3 as Column

RESIDENT Table1;

[#3]

I want logic in sheet not in Script level

[ashfaq_haseeb]

Try like this

Temp:
load * Inline
[
Column1,Column2,Column3
1,2,3
3,1,5
6,5,2
];
NoConcatenate


Main:
load Column1 as Column Resident Temp;
Concatenate(Main)


load Column2 as Column Resident Temp;
Concatenate(Main)
load Column3 as Column Resident Temp;


DROP Table Temp;

Regards

ASHFAQ

[Anonymous · Accepted solution]

Hi

Below is the Expression

=ValueList($(=concat({1} distinct chr(39) & Col1 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col2 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col3 & Chr(39),',')))

Regards

Harsha