topic Re: Append All column in one Column in QlikView

Append All column in one Column

Wed, 12 Nov 2014 12:45:40 GMT

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

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

Regards,

Nisha

Re: Append All column in one Column

marcus_malinow — Wed, 12 Nov 2014 12:47:40 GMT

Table2:

LOAD Column1 as Column

RESIDENT Table1;

CONCATENATE (Table2)

LOAD Column2 as Column

RESIDENT Table1;

CONCATENATE (Table2)

LOAD Column3 as Column

RESIDENT Table1;

Re: Append All column in one Column

Wed, 12 Nov 2014 12:54:56 GMT

I want logic in sheet not in Script level

Re: Append All column in one Column

ashfaq_haseeb — Wed, 12 Nov 2014 12:56:49 GMT

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

Re: Append All column in one Column

Anonymous — Wed, 12 Nov 2014 13:44:23 GMT

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