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