Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to converts all excel files into qvds files at a time in real time senario?

Hi Friends,

For example

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.

1 Reply

Re: how to converts all excel files into qvds files at a time in real time senario?

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;

Community Browser