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