Loading variables from excel

sibrulotte — Fri, 04 Jul 2014 20:16:54 GMT

Hi,

the first part of my script works, but I want to load another set of variables from another tsheet, and that script doesn't work.

LOAD [Réf.calcul règle] as R_Réf_Calcul_Règle,
     [Nom référence] as R_Nom_Réf_Calcul_Règle,
     Champ,
     Comparatif,
     [Valeur référence],
     Nom_variable_QV,
     Clause_Variable_QV
FROM
some file.xlsx
(ooxml, embedded labels, header is 0 lines, table is REGLES_QV);

for i = 0 to NoOfRows('Référentiel_Calcul_Règles') - 1
let vName = peek('Nom_variable_QV', i, 'Référentiel_Calcul_Règles');
let $(vName) = peek('Clause_Variable_QV', i, 'Référentiel_Calcul_Règles');
next i
let vName = null();

Référentiel_Règles:
LOAD [Réf.calcul règle] as [Réf.calcul règleA],
     Description_regle,
     [Description du contrôle],
      Nom_variable_regle
FROM
same file.xls
(ooxml, embedded labels, table is Regles);

for Vi = 0 to NoOfRows('Référentiel_Règles') - 1
let vName1 = peek('Nom_variable_regle', Vi, 'Référentiel_Règles');
let $(vName1) = peek('Description_regle', Vi, 'Référentiel_Règles');
next Vi
let vName1 = null();

The error is :

Script line error:

let vR-PGAF-0001 = peek('Description_regle', Vi, 'Référentiel_Règles')

So this occurs in the second Let once the variable name has already been retrieved, and I'm trying to define it...

Any help is appreciated

Re: Loading variables from excel

felipe_dutra — Sat, 05 Jul 2014 00:01:04 GMT

Hi,

Have you tried that?

let '$(vName1)' = peek('Description_regle', Vi, 'Référentiel_Règles');

Felipe

topic Re: Loading variables from excel in QlikView

Loading variables from excel

Re: Loading variables from excel