Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Import file from folder

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

16 Replies
prma7799
Master III
Master III
Author

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

prma7799
Master III
Master III
Author

Hi,

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

Thanks

prma7799
Master III
Master III
Author

Hi Jagan,

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

Thanks

jagan
Partner - Champion III
Partner - Champion III

HI,

Try like this

TableName:

LOAD

*,

RecNo() AS RowNum,

FileName() AS FileName

FROM *.txt (txt);

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable

Prashant,

Have a look at this:

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

Cheers,

Antoine

anbu1984
Master III
Master III

Temp:

Load * From *.Txt(Txt);

Final:

NoConcatenate

Load *,RecNo() As RowId Resident Temp;

Drop Table Temp;