Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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 :
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]);
thank you so much for helping
I'm trying to fix it but it shows like this, show the fields as attributes
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