Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I'm trying to store data (froman excel file) into a qvd file and it does'nt work.
Here's my script :
Let vCheminQVD='\\Serv-qlikview\qlikview_applications\3_Data\ADM_GFI\QVD\PPI';
PPI_Propective_M14:
LOAD Catégorie,
Signe,
Section,
Chapitre,
[Détail Chapitre],
Compte,
[2013],
[2014],
[2015],
[2016],
[2017],
[2018],
[2019],
[2020],
[2021],
[2022]
FROM
[\\Serv-qlikview\qlikview_applications$\3_Data\ADM_GFI\XLS\PPI_Qvw.xls]
(biff, embedded labels, header is 1 lines, table is [Prospective QW BG $]);
Store PPI_Propective_M14 into $(vCheminQVD)\PPI_Propective_M14.qvd (qvd);
drop table PPI_Propective_M14;
I can't figure out why it doesn't work. Any idea ?
Thanks,
Sarah
Can you check if the path is an issue. Your excel file is loaded from qlikview_applications$ where as variable is storing it to qlikview_application (without a dollar sign)
I would thing that the two would match up?
Can you check if the path is an issue. Your excel file is loaded from qlikview_applications$ where as variable is storing it to qlikview_application (without a dollar sign)
I would thing that the two would match up?
Indeed it works with the '$', Thank you !