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

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

Wed, 15 Jul 2015 12:20:43 GMT

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

Can any provide solution for above Question?

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

Gysbert_Wassenaar — Wed, 15 Jul 2015 12:23:43 GMT

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

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

Wed, 15 Jul 2015 12:49:22 GMT

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);

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

tcullinane — Wed, 15 Jul 2015 12:54:47 GMT

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?

Gysbert_Wassenaar — Wed, 15 Jul 2015 12:55:00 GMT

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.

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

tulsidaskhan — Thu, 05 May 2016 13:25:21 GMT

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.

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

oscar_ortiz — Fri, 06 May 2016 18:55:09 GMT

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

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

tulsidaskhan — Mon, 09 May 2016 11:11:12 GMT

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

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

Gysbert_Wassenaar — Mon, 09 May 2016 15:36:37 GMT

* is for 0 or more wildcard characters.

? is for one wildcard character.

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

tulsidaskhan — Mon, 09 May 2016 17:12:12 GMT

got it. thanks.