I have a table that has various columns with data. Five of those columns I would like to make into a single column and use the headings as the row data. Below is an example of what I am talking about. Is there a way to code this to work? I do not think an Inline table would work because the data can have multiple values. Any help is greatly appreciated.
The file I am trying to change is a QVD. Is there a way for me to create another table to have the data the way I want and then join back to the original table to bring in the other data values I need?
another solution could be a crosstable load, especially when having more than one row of persons in your source table:
CrossTable (Role, User)
LOAD RecNo() as %Key, *
Fiscal Contract, Fiscal Officer, Approver, Project Manager, Project Examiner
Person A, Person B, Person C, Person B, Person B
Person D, Person E, Person F, Person D, Person E
Person G, Person G, Person H, Person I, Person J
see also Crosstable ‒ QlikView
hope this helps
My apologies on my post. The file I am trying to update is not an excel file. I just used excel to show what I wanted to do. The data is in a QVD that I am trying to manipulate.
My apologies - forgot that transform will only work on the data and not on the columns!
You will have to read from QVD - store to a temp excel file, and then you read from excel (with no header) and tranpose it!
Or use cross tab on the QVD load -->
LOAD [Fiscal Contact],
'' as Test,
DROP Table Test;
drop Field Test;