Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to load multiple Excel files data in single load statement?

How to load multiple Excel files data in single load statement?

Can any provide solution for above Question?

9 Replies

Re: How to load multiple Excel files data in single load statement?

LOAD * FROM C:\MyData\*.xlsx (ooxml, embedded labels, table is Sheet1);


talk is cheap, supply exceeds demand
Not applicable

Re: How to load multiple Excel files data in single load statement?

Thanks Gysbert Wassenaar, it is working fine.

What is OOXML and biff?  IS there any other commands for CSV and other formats?

For XLS below command is working fine.

LOAD * From D:\Documents\Bhargav\Data sources\*.xls(biff,embedded labels);

But it is not working with CSV format.

LOAD * From D:\Documents\Bhargav\Data sources\*.csv(biff,embedded labels);

tcullinane
Contributor II

Re: How to load multiple Excel files data in single load statement?

best to load a single file, make sure the format is correct, headers etc. then replace the file name with * to load all files from the folder... assuming they all have the same format

Re: How to load multiple Excel files data in single load statement?

Biff is the .xls excel format. If you load from text files you need another format. It's easiest to use the Table Files button in the load editor and locate the file. You can then select what type of file you're going to load.


talk is cheap, supply exceeds demand
tulsidaskhan
New Contributor

Re: How to load multiple Excel files data in single load statement?

Hi Gysbert,

Following Load script will pick up all the files in Data source.

LOAD * From D:\Documents\ABC\Data sources\*.csv(biff,embedded labels);

what if I have different files like Test_21/04/2016 , Test_22/04/2016.

I have seen solution to this like adding ?? instead of *. could you please let me know how we use '?'

in load statement.

oscar_ortiz
Valued Contributor

Re: How to load multiple Excel files data in single load statement?

The question mark (?) is a single character wildcard.

tulsidaskhan
New Contributor

Re: How to load multiple Excel files data in single load statement?

ok.So instead of *,I can also use '?'. Is it?

Re: How to load multiple Excel files data in single load statement?

* is for 0 or more wildcard characters.

? is for one wildcard character.


talk is cheap, supply exceeds demand
tulsidaskhan
New Contributor

Re: How to load multiple Excel files data in single load statement?

got it. thanks.

Community Browser