Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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?

3 Replies
sridhar240784
Not applicable

Re: Convert data value into Field with values

'Generic Load' will hlpe you to do this.

Check the attached application.

Hope this helps you.

-Sridhar

Not applicable

Re: Convert data value into Field with values

Hi,

take a look into attached qvw.

regards,

K. Pap

Not applicable

Re: Convert data value into Field with values

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!