Dynamic Column

[mikecoffey]

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.