I am working on importing a data source where I have a "Property" and a "Value" column. The row values of the "Property" column needs to be transformed into column field names in QlikView with corrosponding values. The specific content of the "Properties" can differ from time to time so it needs to be dynamic and create a new field if a new value in the column pops up. I have attached an example in Excel and how it is wanted loaded. How can this be done? I know the crosstable command but that turns columns into rows. Now I need to turn rows into columns. Is this possible?
Thank you very much for the replies. The generic load can do the trick, however the resulting data model can look terrible when working with a large dataset. The suggestion in #2 looks fantastic. I will work with both and see what can fit best. Thank you very much for the replies!