Hello,
I have a unique challenge to pivot the data prior to loading into QlikSense so I can use that table in NPrinting pdf.
I have pivoted the data in the load script but I'm struggling with how to create a dynamic table based off the pivoted columns.
Sample data:
InlineTable:
load
*
inline [
Name,'4/1/2020','4/2/2020'
A, 1, 4
B, 2, 5
C, 3, 6
]
;
Based on the data I can create a straight table that looks like the attached. What I would like to accomplish is have the columns be dynamic so when it loads tomorrow it will pick up the new date as a column without having to add it to the table.