Discussion Board for collaboration on QlikView Scripting.
I have A,B,C,D,E,F,G,H,I,J,K & etc.. Excels file will be there in system. Now, i want convert all excel files at a time into QVDs files.
Could please explain and send code to this post.
You have to load all the xlsx files (if they have the same structure) then store into qvd.
here it is the code
let path = '..\..\qlik\myExcelFile_*.xlsx'; for each File in filelist (path) MYTABLE: LOAD filed1, field2, ... fieldn FROM $(File) (ooxml, embedded labels, table is Foglio1); next File Store * from MYTABLE into MYTABLE.qvd;