Thanks Kakani, but I am in need of a dynamic load script to create the cross table.
I have a large table if records with many other attributes. I also have a second table (columns) that I need to use as the reference for the data load from the records table. The columns table will change weekly so I will need to update the columns table. my records table is thousands of rows and hundreds of columns.
I am new to qliksense and I am struggling with looping variables and referencing.
FOR Each a in FieldValueList('Columns')
LOAD '$(a) as NEWFIELD AutoGenerate 2;