Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
john9inno
Contributor

Extraction all file in one folder

Hi all,

the problem i have is very annoying for so long.

I have a group of people feed me same type of report every week.

thoes are saved in one folder with different name.

Have asked to save it same name but never worked.

it is like

file 1 - A2.TXT

File 2 - a2.TXT

File 3 - A_2.TXT and so on.

is it possible to extract data from all file in one location automatically?

any comment will be appreciated.

thanks.

Tags (3)
1 Solution

Accepted Solutions

Re: Extraction all file in one folder

Hi,

Try like

Temp:

load *

from filepath/*.txt

store Temp into filePAth/TempTxt.qvd;

drop table Temp;

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
2 Replies

Re: Extraction all file in one folder

Hi,

Try like

Temp:

load *

from filepath/*.txt

store Temp into filePAth/TempTxt.qvd;

drop table Temp;

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
john9inno
Contributor

Re: Extraction all file in one folder

thanks so much!

Community Browser