crosstable in script editor

[dosaril]

Hi,

I'm new to Qlik Sense and am working on editing the script to convert many rows into columns using the CROSSTABLE function. I’m trying to apply this transformation for each row field, but when I check the Data Model Viewer, I see that several tables have been created.

Can someone help me understand why multiple tables are appearing and how I can correct this issue?

This is my Function:

CrossTable(Month,ProjectName,6)
LOAD
F1,
"45474",
"45505",
"45536",
"45566",
"45597",
"45627"
FROM [lib://AttachedFiles/Sample v1.1.xlsx]
(ooxml, embedded labels, table is [Project Report Template]);

I have attached an Excel file that I’m trying to convert using the Data Load Editor

Thank you!

[QFabian]

Hi @dosaril , just change the 6 to 1. The third crosstable function parameter set the numbers of columns to not cross, keeping as rows. Check this too :

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/...

CrossTable(Month,ProjectName,1)
LOAD
F1,
"45474",
"45505",
"45536",
"45566",
"45597",
"45627"
FROM [lib://AttachedFiles/Sample v1.1.xlsx]
(ooxml, embedded labels, table is [Project Report Template]);

[dosaril]

thank you so much for helping 

I'm trying to fix it but it shows like this, show the fields as attributes 

[dosaril]

hello 

thank you for your help ,

I'm still trying to edit the issue, but the field still appear as attribute

please if you can help me on that 

thank you