Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have data
I want to transform tagID from column to row
Please see my attached files.
Thanks,
I got it
Generic
LOAD respondentID, comeTime,
'question' &questionID,
tagID;
If I use Generic LOAD, I have thounds tables.
Explain better what you want !!
Each respondent has 2 rows. I want to have for each respondent all value in 1 row.
TO
If questionID=1, value of tagID should be in Field questionID1
If questionID=3, value of tagID should be in Field questionID3
Thanks,
I got it
Generic
LOAD respondentID, comeTime,
'question' &questionID,
tagID;