topic Re: Uploading data files to a specific folder in QlikView

Uploading data files to a specific folder

bilionut — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to loading data from a range of folders like that:

..\ AAA \ 2015_12 \
..\ AAA \ 2016_01 \
..\ AAA \ 2016_02 \
...
..\ AAA \ 2016_12 \

How can I address a file from a specific folder in a row, for example, at the earliest month or the latest one?

Re: Uploading data files to a specific folder

qlikview979 — Thu, 18 May 2017 07:31:01 GMT

Do like this in your script

filepath() as Folder path

Re: Uploading data files to a specific folder

avinashelite — Thu, 18 May 2017 07:36:22 GMT

To get the files path as a column use

FilePath() as path in the script

if you want yo load the latest files then check this

Load latest Excel file to Qlikview

Re: Uploading data files to a specific folder

bilionut — Thu, 18 May 2017 10:16:14 GMT

Thanks a lot Avinash R!

This link is what I needed