3 Replies Latest reply: Oct 7, 2011 7:15 AM by Theis Hartvig Poulsen RSS

    Convert data value into Field with values

      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?