Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

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;