topic QlikView Column to Row Table in QlikView

QlikView Column to Row Table

Anonymous — Tue, 22 Sep 2015 20:33:59 GMT

I've a data set in the following format

Data set

Response question answer

1 1 Name 1

1 2 Yes

2 1 Name 2

2 2 No

3 1 Name 3

3 2 Yes

I want to create a table as shown below -

Response Names Yes / No

1 Name 1 Yes

2 Name 2 No

3 Name 3 Yes

Can someone please help?

Re: QlikView Column to Row Table

hic — Tue, 22 Sep 2015 20:39:43 GMT

You should use a Generic Load. See The Generic Load

HIC

Re: QlikView Column to Row Table

Anonymous — Tue, 22 Sep 2015 21:12:49 GMT

Thank you.

Is there another way to do this using functions.

Re: QlikView Column to Row Table

petter — Tue, 22 Sep 2015 21:24:28 GMT

You could do it like this - but I guess it is much less efficient than doing a GENERIC LOAD - the benefit is that you get a single table immediately:

[Data set]:

LOAD * INLINE [

Response question answer

1 1 Name 1

1 2 Yes

2 1 Name 2

2 2 No

3 1 Name 3

3 2 Yes

] (delimiter is \t);

[Result Table 1]:

LOAD Response AS Response#,

SubField( answer , '|' , 1 ) AS Names,

SubField( answer , '|' , 2 ) AS [Yes / No];

LOAD

Response,

Concat( answer , '|' ) AS answer

RESIDENT

[Data set]

GROUP BY

Response;

DROP TABLE [Data set];

Re: QlikView Column to Row Table

jolivares — Tue, 22 Sep 2015 21:42:59 GMT

Hi Henric, I beg your pardon to to try to get you by this way, but I have an unsolved issue depicted in this ticket. I am not satisfied with the solution found it.

May you please see this. Thanks at all.

Re: How to get the correct Rowno