topic Concatenate Multiple csv Files with Filenames in QlikView

Concatenate Multiple csv Files with Filenames

haymarketpaul — Fri, 04 Apr 2014 09:35:11 GMT

Hi All

I have over 2000 csv files in a folder all with exactly the same structure and i need to concatenate them all together.

I am thinking i can do something like this as they will auto concatenate but I also need to store in a field the name of the file where each record came from and I am unsure how best to achieve that. Any advice welcome.

For each File in FileList('$(vPath)\*.csv')

TableName:

Load

Field1,

Field2,

FieldN

From $(File);

NEXT

Re: Concatenate Multiple csv Files with Filenames

Fri, 04 Apr 2014 09:47:05 GMT

Hi ,

Check this thread

http://community.qlik.com/thread/113019

Re: Concatenate Multiple csv Files with Filenames

rustyfishbones — Fri, 04 Apr 2014 09:47:55 GMT

Hi Paul,

Select one file from the csv files

add this to your script to get the filename

FileName() as Filename

and to load all 2000 csv files place a * after the part of the filename most common with all 2000 csv's

Alan

Re: Concatenate Multiple csv Files with Filenames

rustyfishbones — Fri, 04 Apr 2014 09:49:17 GMT

Also check a video by Steve Dark on youtube called

Qlikview - Loading Data from Multiple Files

Re: Concatenate Multiple csv Files with Filenames

haymarketpaul — Fri, 04 Apr 2014 09:51:49 GMT

That looks very useful, and may just do the trick - thanks

Re: Concatenate Multiple csv Files with Filenames

haymarketpaul — Fri, 04 Apr 2014 09:52:27 GMT

All filenames are completely different sadly

Re: Concatenate Multiple csv Files with Filenames

haymarketpaul — Fri, 04 Apr 2014 09:52:51 GMT

Thanks - i'll take a look at that

Re: Concatenate Multiple csv Files with Filenames

rustyfishbones — Fri, 04 Apr 2014 10:05:08 GMT

If the names are completely different it's fine just say

myfolderstructure\*.csv

Re: Concatenate Multiple csv Files with Filenames

haymarketpaul — Fri, 04 Apr 2014 10:29:16 GMT

Perfect - Thank you - easier than i thought