topic Re: Converting a single row to a column in QlikView

Converting a single row to a column

aniketsr — Mon, 07 Oct 2013 07:14:00 GMT

Hi,

I have a scenario where the data is on the format below,

but we need to save the data in the Qvd in the below given format,

Kindly help me wid the same

tresB — Mon, 07 Oct 2013 07:18:54 GMT

Have a look at CROSSTABLE() functionality.

MayilVahanan — Mon, 07 Oct 2013 07:22:07 GMT

Try like this

Crosstable(SrNo,Answers,2)

Load

From tablename;

Mon, 07 Oct 2013 07:25:39 GMT

check attached file. I have used cross table.

jagan — Mon, 07 Oct 2013 07:37:04 GMT

Hi,

Try like this using Crosstable

CrossTable

(SrNo., Answer)
LOAD *
INLINE [
Qno, 21, 39, 46, 102
1A, Yes, Yes, Yes, Yes
1B, Yes, NO, Yes, Yes
1C, Yes, NO, NO, Yes
1D, Yes, NO, Yes, Yes
];

Regards,

Jagan.

MayilVahanan — Mon, 07 Oct 2013 07:48:34 GMT

Try like this

CrossTable

(SrNo., Answer)

LOAD Qno,

[21],

[39],

[46],

[102]

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1);

Mon, 07 Oct 2013 08:01:37 GMT

Hi,

PFA