Changing row column to value.

[Dilie]

I load in my data from JIRA with the REST connector. Now in this way the values of this table are put as column names.

My data is now like this:

custom_field1 | custom_field2 | custom_field3

Rank                        Support              Help

I want it to change to this:

id                            | value

custom_field1  | Rank

custom_field2  | Support

custom_field3  | Help

Could anyone help me with this or put me in the right direction with documentation? English is not my first language so I don't know how to specify searching for this.

[Vegar · Accepted solution]

You can solve this by using Crosstable 

Crosstable(Entity, Value, 1)

Load '' as dummy, custom_field1, custom_field2, custom_field3

From Source ;

Drop field dummy;

I'm using dummy field as the funtion needs at least one qualifying (not pivot) field.

Read more on crosstable here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes...

[Dilie]

Thanks it worked I have a lot of those columns, is there any way to loop through these columns and do the same? I need to learn how this crosstable works but after testing it works. 

Thanks for your help!