I have a records table (records) that I want to dynamically load individual columns based on another table (column).
my original table has hundreds of columns.
I need a cross table with only the specific columns in the column table.
I am trying to create a loop but I have been unsuccessful.
Is this even possible?
load * inline [
After loading this script now in frontend List box add measure as
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;