topic Re: handle duplicate files while loading multiple files from a folder in QlikView

handle duplicate files while loading multiple files from a folder

kushalthakral — Fri, 09 May 2014 15:04:58 GMT

Hi All

i want to load multiple files from a folder

so how i can achieve this and also handle if there are duplicate files

like i have files with name

sales_20140203

sales_20140305

Thanks

Kushal Thakral

Re: handle duplicate files while loading multiple files from a folder

kushalthakral — Sat, 10 May 2014 05:34:55 GMT

Hi All

Any one has solution for this.

Thanks

Kushal Thakral

Re: handle duplicate files while loading multiple files from a folder

swuehl — Sat, 10 May 2014 09:53:43 GMT

You can use a wildcard in your file name, like

LOAD Field1, Field2 FROM sales_*.xls

(biff, embedded labels, table is Sheet1$);

Or use a loop, like shown in the HELP

FOR Each File in filelist (Root&' \*.' &Ext)
LOAD
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime( '$(File)' ) as FileTime
autogenerate 1;
NEXT File

I don't think you can have duplicate file names in the same directory.

Re: handle duplicate files while loading multiple files from a folder

kumarnatarajan — Sat, 10 May 2014 10:40:45 GMT

Hi,

Try below script. Include * instead of your file date Ex: sales_*

Load FieldName1,

FieldName2,

..........

From

sales_*;

Re: handle duplicate files while loading multiple files from a folder

kushalthakral — Mon, 12 May 2014 04:34:54 GMT

Thanks Swuehl

It helped me alot

Regards

Kushal Thakral