how to extract multiple files in qlikview?

[#1]

Hi all,

I am new to qlikview. anyone can help me.

[agilos_mla · Accepted solution]

Hi Murali,

It can depends on how look like the files.

If always the same data structure and filenames are built with naming convention you can insert * in the load statement:

ie. My files are DataFile_2012.xlsx, DataFile_2013, DataFile2014, i can use : DataFile_*.xlsx

LOAD   *

FROM [DataFile_*.xlsx]

(ooxml....)

Michael

[#3]

Thanks Michael