topic Re: Import file from folder in QlikView

Import file from folder

prma7799 — Tue, 10 Feb 2015 04:19:58 GMT

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

Re: Import file from folder

prma7799 — Tue, 10 Feb 2015 04:21:12 GMT

Re: Import file from folder

jagan — Tue, 10 Feb 2015 04:25:03 GMT

Hi,

Try like this using wildcard characters

LOAD

FROM *.txt (txt);

Hope this helps you.

Regards,

Jagan.

Re: Import file from folder

anbu1984 — Tue, 10 Feb 2015 04:26:54 GMT

Source:

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

Re: Import file from folder

prma7799 — Tue, 10 Feb 2015 04:36:15 GMT

Error: File Exadata.cpp,Line 2897

Re: Import file from folder

prma7799 — Tue, 10 Feb 2015 04:41:15 GMT

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

Re: Import file from folder

anbu1984 — Tue, 10 Feb 2015 04:51:53 GMT

Did remaining files appended to table Not4?

Re: Import file from folder

jagan — Tue, 10 Feb 2015 04:53:44 GMT

Hi,

Is all tables having different data?

Try this

TableName:

LOAD

FileName() AS FileName

FROM *.txt (txt);

Regards,

Jagan.

Re: Import file from folder

prma7799 — Tue, 10 Feb 2015 05:17:41 GMT

Hi,

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

The output is not coming proper.

Re: Import file from folder

anbu1984 — Tue, 10 Feb 2015 05:37:58 GMT

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

Re: Import file from folder

prma7799 — Tue, 10 Feb 2015 05:53:42 GMT

Hi Anbu,

This Is for only one excel file what about another excel files that I want to load within a one reload.

Thanks

Prashant

Re: Import file from folder

prma7799 — Tue, 10 Feb 2015 05:57:14 GMT

Hi,

I want to load multiple excels sheets in a single load.

Thanks

Re: Import file from folder

anbu1984 — Tue, 10 Feb 2015 06:07:11 GMT

Load multiple sheets and excel files

Re: Import file from folder

prma7799 — Tue, 10 Feb 2015 06:14:13 GMT

Hi Jagan,

How to merge all txt file into one file and how to bifurcate to this with row id with each line.

Thanks

Re: Import file from folder

jagan — Tue, 10 Feb 2015 07:58:18 GMT

HI,

Try like this

TableName:

LOAD

RecNo() AS RowNum,

FileName() AS FileName

FROM *.txt (txt);

Hope this helps you.

Regards,

Jagan.

Re: Import file from folder

Anonymous — Tue, 10 Feb 2015 08:10:14 GMT

Prashant,

Have a look at this:

loop through to load all files from a folder and its subfolders?

Cheers,

Antoine

Re: Import file from folder

anbu1984 — Tue, 10 Feb 2015 08:15:36 GMT

Temp:

Load * From *.Txt(Txt);

Final:

NoConcatenate

Load *,RecNo() As RowId Resident Temp;

Drop Table Temp;