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

[#1]

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

Can any provide solution for above Question?

[Gysbert_Wassenaar]

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

[#3]

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]

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

[Gysbert_Wassenaar]

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.

[tulsidaskhan]

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]

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

[tulsidaskhan]

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

[Gysbert_Wassenaar]

* is for 0 or more wildcard characters.

? is for one wildcard character.

[tulsidaskhan]

got it. thanks.