Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load statement from external file

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

0 Replies