Hi,
The input file (excel) has the following column headers
Name, Product, 202101,202102,202103,202104,202105,202106,202107
202102 --> This filed represents some values for year 2021 and month Jan.
What i need is, while processing the input file in qlikview, i need to store the columns names (fields) into variables so that, i can create the load statement as follows
Inputload:
Load Name, Product, [var1],[var2],[var3],[var4],[var5],[var6],[var7]
from <<excelfile>>;
This way i need to ensure the fieldsname are dynamically stored in variables for next year as well like if next year the input file has 202201,202202.... etc.. the qlik script load should pick up the new field names.
Any thoughts pls.
Thank you
Sean.