Extraction all file in one folder

[john9inno]

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 · Accepted solution]

Hi,

Try like

Temp:

load *

from filepath/*.txt

store Temp into filePAth/TempTxt.qvd;

drop table Temp;

Regards

[john9inno]

thanks so much!