topic Re: Extraction all file in one folder in QlikView

Extraction all file in one folder

john9inno — Fri, 16 Jan 2015 05:09:02 GMT

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.

PrashantSangle — Fri, 16 Jan 2015 05:14:02 GMT

Hi,

Try like

Temp:

load *

from filepath/*.txt

store Temp into filePAth/TempTxt.qvd;

drop table Temp;

Regards

john9inno — Tue, 20 Jan 2015 00:50:35 GMT

thanks so much!