Load statement from external file

Wed, 25 Nov 2020 16:16:04 GMT

Hello QV community,

I'm having some issue in loading QVDs. Here's my case :

I'm storing my variables in an excel file called 'variables.xls' with this structure :

VariableName ! VariableValue ! FieldsName

VariableValue contains the name of my different QVD to load.

FieldsName contains the list of my different fields related to each QVD.

First of all i loaded my variable list from variables.xls :

-------------------------

variables:

LOAD NomVariable,

Valeur

FROM

[..\00_Configuration\Fichiers\variables.xls]

(biff, embedded labels, table is Feuille1$);

Let vNombreLigne = NoOfRows('variables');

for vI=0 to $(vNombreLigne)

Let vDimensions = peek('VariableName',vI,'variables');

Let [$(vDimensions)] = peek('VariableValue',vI,'variables');

next;

------------------------

My issue now is in the load statement. How can i load my files using the $(vDimensions) variable and its fields automatically.

Yours

topic Load statement from external file in QlikView