Import file from folder

[prma7799]

Hi All,

I have one folder and in that folder have multiple .txt files with same or different name and my user will create one or more file every day.

So what  I want is whatever user create file in that folder I need to automatically fetch and reload the files from that folder .

Folder Name is :"Test for txt"

and for file names please find the screenshot.

Thanks
Prashant

[prma7799]

[jagan]

Hi,

Try like this using wildcard characters

LOAD

*

FROM *.txt (txt);

Hope this helps you.

Regards,

Jagan.

[anbu1984]

Source:

Load * From c:\Test for txt\*.txt

[prma7799]

Error: File Exadata.cpp,Line 2897

[prma7799]

error is resolve but only 7 file is come what about remaining files

[anbu1984]

Did remaining files appended to table Not4?

[jagan]

Hi,

Is all tables having different data? 

Try this

TableName:

LOAD

*,

FileName() AS FileName

FROM *.txt (txt);

Regards,

Jagan.

[prma7799]

Hi,

If I fetching xlsx file (Load * From C:\Users\a185_o_bi2support\Desktop\Test for txt\*.xlsx; )

The output is not coming proper.

[anbu1984]

You can load excel file by clicking "Table Files" in Edit script and select the excel file you want to load which will automatically create the script for you

LOAD *

FROM

[Sample.xlsx]

(ooxml, embedded labels, table is TableName); //This is missing in your load statement