Load CSV and use description in field as column name

[SK_83]

I have a csv file like the screenshot below:

What I am trying to achive is to load this file and use the description in the field as a columnheader for the value. The result should look like this:

kind regards in advance!

[MatheusC]

Hi, @SK_83 

You can try with the Crosstable function, see this documentation

https://help.qlik.com/pt-BR/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefix...

[rwunderlich]

I think you want to use Generic Load here:

Data:
Generic Load RecNo() as RecId, [Field 7], [Value 7] from ...;
Generic Load RecNo() as RecId, [Field 8], [Value 8] from ...;
Generic Load RecNo() as RecId, [Field 9], [Value 9] from ...;

See https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefix...

If you want script to subsequently join the generic tables into a single table, see https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com