Import data from excel file which fields as variables

Sean_BI — Mon, 19 Jul 2021 16:14:46 GMT

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.

topic Import data from excel file which fields as variables in QlikView

Import data from excel file which fields as variables