Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
Je souhaite intégrer un fichier table Excel avec plusieurs onglets.
Est il possible de variabiliser l'intégration ?
Les onglets portent les nom 121031/120930/120831 etc...
Bonjour,
Oui.
Exemple :
…
// declaration de variable
Let vNomOnglet=’Sheet1’ ;
// traitement de chargement
Load * from
LOAD *
FROM
(ooxml, embedded labels, table is $(vNomOnglet));
Si vous souhaitez parcourir votre liste d’onglets sous la forme d’une boucle, c’est possible également.
Vous trouverez un exemple type dans le QlikView reference manual à l’instruction For…Next à la page 231 du manuel V11.
Cdt
Christophe Jouve
Pre-sales solutions consultant
Direct: +33 1 55 62 65 54
Mobile: +33 6 76 24 22 47
Email: Christophe.Jouve@qlik.com
QlikTech France
93 avenue Charles de Gaulle
92200 Neuilly sur Seine
qlik.com<http://www.qlik.com/>
18 octobre 2012 | De la Business Intelligence à la Business Discovery...
http://www.qlikview.fr/BDWT-Paris
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
Bonjour,
Oui.
Exemple :
…
// declaration de variable
Let vNomOnglet=’Sheet1’ ;
// traitement de chargement
Load * from
LOAD *
FROM
(ooxml, embedded labels, table is $(vNomOnglet));
Si vous souhaitez parcourir votre liste d’onglets sous la forme d’une boucle, c’est possible également.
Vous trouverez un exemple type dans le QlikView reference manual à l’instruction For…Next à la page 231 du manuel V11.
Cdt
Christophe Jouve
Pre-sales solutions consultant
Direct: +33 1 55 62 65 54
Mobile: +33 6 76 24 22 47
Email: Christophe.Jouve@qlik.com
QlikTech France
93 avenue Charles de Gaulle
92200 Neuilly sur Seine
qlik.com<http://www.qlik.com/>
18 octobre 2012 | De la Business Intelligence à la Business Discovery...
http://www.qlikview.fr/BDWT-Paris
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
Merci
Bonjour,
Vous trouverez en pièce jointe un petit exemple qui devrait convenir à votre besoin. J’ai mis des commentaires dans le script pour vous aider.
Cdt
Christophe Jouve
Pre-sales solutions consultant
Direct: +33 1 55 62 65 54
Mobile: +33 6 76 24 22 47
Email: Christophe.Jouve@qlik.com
QlikTech France
93 avenue Charles de Gaulle
92200 Neuilly sur Seine
qlik.com<http://www.qlik.com/>
18 octobre 2012 | De la Business Intelligence à la Business Discovery...
http://www.qlikview.fr/BDWT-Paris
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.