Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

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;