topic How to Separate fields with same ID into two columns in QlikView

How to Separate fields with same ID into two columns

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following data in my QV table

I would my table to show distinct ID and associated subjects - so this is want I'd like to output

Any suggestions please

Thanks

JazzyK

andydietler — Thu, 23 Aug 2018 17:00:21 GMT

Are there only a maximum of 2? You could create a more dynamic loop if there are more, but this should work for two:

NewTable:

LOAD

ID,

Subject AS Subject1

Resident CurrentTable

WHERE Not ID = Previous(ID)

ORDER BY ID, Subject;

Left Join (NewTable)

LOAD

ID,

Subject AS Subject2

Resident CurrentTable

WHERE ID = Previous(ID)

ORDER BY ID, Subject;

Anonymous — Thu, 23 Aug 2018 17:03:58 GMT

No I have 4870 IDs and 4999 subjects. I just provided a sample. I really wanted do this as an expression in a table.

Thanks

Jasmit

Anonymous — Thu, 23 Aug 2018 17:29:00 GMT

Thank you. That worked perfectly. I managed to put it into the script.