topic Convert data value into Field with values in QlikView

Convert data value into Field with values

Wed, 05 Oct 2011 13:05:06 GMT

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?

Re: Convert data value into Field with values

sridhar240784 — Wed, 05 Oct 2011 14:34:05 GMT

'Generic Load' will hlpe you to do this.

Check the attached application.

Hope this helps you.

-Sridhar

Re: Convert data value into Field with values

Fri, 07 Oct 2011 10:27:01 GMT

Hi,

take a look into attached qvw.

regards,

K. Pap

Re: Convert data value into Field with values

Fri, 07 Oct 2011 11:15:56 GMT

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!