topic Re: How to Concatenate values in different columns into One Column in QlikView

How to Concatenate values in different columns into One Column

Mon, 13 Apr 2015 17:26:40 GMT

Hi,

I have a table that looks like this.

ColumnA	ColumnB	ColumnC	ColumnD
A	D	C	F
B	E	-	G
C	A	-	H
-	B	-	-

I want to append ColumnA followed by ColumnB followed by ColumnC followed by ColumnD, and the final "ResultColumn" must look like:

I understand in QlikView it is not possible to display same values twice under one column. In that case the final "ResultColumn" may look like this

ResultColumn

I tried concatenate, but it puts all values in once cell, which is wrong. Concatenate looks like this: ABCDEFGH

I appreciate your response.

Thanks,

Re: How to Concatenate values in different columns into One Column

sunny_talwar — Mon, 13 Apr 2015 17:30:48 GMT

Try it like this:

Table:

LOAD ColumnA as ResultColumn

Resident XYZ;

Concatenate (Table)

LOAD ColumnB as ResultColumn

Resident XYZ;

Concatenate (Table)

LOAD ColumnC as ResultColumn

Resident XYZ;

Concatenate (Table)

LOAD ColumnD as ResultColumn

Resident XYZ;

HTH

Best,

Sunny

Re: How to Concatenate values in different columns into One Column

sunny_talwar — Mon, 13 Apr 2015 17:37:06 GMT

Take a look at the attached code and application:

Temp:

LOAD ColumnA,

ColumnB,

ColumnC,

ColumnD

FROM

[https://community.qlik.com/thread/159869]

(html, codepage is 1252, embedded labels, table is @1);

Table:

LOAD ColumnA as ResultColumn

Resident Temp

Where ColumnA <> '-';

Concatenate (Table)

LOAD ColumnB as ResultColumn

Resident Temp

Where ColumnB <> '-';

Concatenate (Table)

LOAD ColumnC as ResultColumn

Resident Temp

Where ColumnC <> '-';

Concatenate (Table)

LOAD ColumnD as ResultColumn

Resident Temp

Where ColumnD <> '-';

TableFinal:

LOAD RowNo() as Key,

ResultColumn

Resident Table;

DROP Tables Temp, Table;

Re: How to Concatenate values in different columns into One Column

Mon, 13 Apr 2015 18:09:56 GMT

Hi SunIndia,

I applied to your script to my original code and it works. Thanks for your promt response.

Thanks,

Raghu

Re: How to Concatenate values in different columns into One Column

sunny_talwar — Mon, 13 Apr 2015 18:12:42 GMT

Hey Raghu, I am glad I was able to help.

Have a good one.

Best,

Sunny