Import data from excel file which fields as variables

[Sean_BI]

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.