topic Transform Field to row in QlikView

Transform Field to row

Anonymous — Thu, 16 May 2013 17:43:16 GMT

Hello,

I have data

I want to transform tagID from column to row

Please see my attached files.

Thanks,

Anonymous — Thu, 16 May 2013 18:07:35 GMT

If I use Generic LOAD, I have thounds tables.

Thu, 16 May 2013 18:16:17 GMT

Explain better what you want !!

Anonymous — Thu, 16 May 2013 18:33:22 GMT

Each respondent has 2 rows. I want to have for each respondent all value in 1 row.

If questionID=1, value of tagID should be in Field questionID1

If questionID=3, value of tagID should be in Field questionID3

Thanks,

Anonymous — Thu, 16 May 2013 18:45:15 GMT

I got it

Generic

LOAD respondentID, comeTime,

'question' &questionID,

tagID;