topic Loading csv files from multiple folders in QlikView

Loading csv files from multiple folders

fishmanl — Fri, 15 Jan 2021 23:35:17 GMT

Hi all,

I need to load same structure csv files from 3 different folders locatted in on folder.

(3 stores of , each has its own sales csv files)

Also i need to gave the option to choose how many days of csv files i am uploading. (Each csv by its creation date)

Thank you

Vegar — Sat, 16 Jan 2021 08:03:21 GMT

You can loop through files and folder using for each loops. And use filetime() to check the date of your file.

Try something like the sample I have typed below.

For each _folder in 'location/1', 'location/2', 'location/3'

For each _csv in filelist ('$(_folder) /*.csv')

If filetime('$(_csv)') > dayname(today() - 21) then

Load * from [$(_csv)] (txt);

End If

Next _csv

Next _folder

fishmanl — Sat, 16 Jan 2021 10:48:37 GMT

thank you for the replay.

im kind new to Qlik , can you be more spacific please?

the main folder is: '\\182.19.38.22\Data\BiFiles\'

the 3 folders located in this main folder are: LM,LN,LT

and the files in each: SalesDetail_*.csv

can you please write the full syntacs?

fishmanl — Sat, 16 Jan 2021 11:54:15 GMT

and if its possible i want the folders to be in a var so i don't need to specific every location sparely

Vegar — Sat, 16 Jan 2021 11:57:46 GMT

For each _folder in 'LM' ,'LN','LT'

For each _csv in filelist ('\\182.19.38.22\Data\BiFiles\$(_folder)\SalesDetail_*.csv')

If filetime('$(_csv)') > dayname(today() - 21) then

Load * from [$(_csv)] (txt);

End If

Next _csv

Next _folder

fishmanl — Sat, 16 Jan 2021 20:09:32 GMT

Thank you very much!