If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a table that has a single row of values and more than 100 columns
Here is the example
and expected output is
I need a Data load editor script for this, please?
Thanks in advance
Transform:Crosstable(Columns, Flag)LOAD1 as Field1,*FROM [lib://Data/Convert to Straight table script in data load editor.xlsx](ooxml, embedded labels, header is 1 lines, table is Sheet1);
Drop Field Field1;
You need to have one field to keep before Crosstable function. This can be a dummy field that you drop after the transformation.
View solution in original post
Thank you, Lisa, It's working now.
Field1 has resolved the issue, Thank you so much