This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Is it possible in Qlikview to check if a csv-file is in a map and if it is, Qlikview should read this file.
The filename of the csv file is variable. It always starts with Time and a date.
Time20161215.csv, Time20161214, ...
Is it possible that if a file with Time*.csv exist I read all the Time*.csv files.
Can I make this script variable? Like
IF (NOT isNull(qvdCreateTime('..\\FileLocation\Time*.csv'))) THEN
But this isn't working.
This is what I have, but the first line in the script should be variable.
IF (NOT isNull(qvdCreateTime('..\\FileLocation\Time20161215.csv'))) THEN
Load @1 as Number,
@2 as Name
(txt, codepage is 1252, explicit labels, delimiter is ';', header is 1 lines);
Use a simple loop:
For each vFile in FileList('..\\FileLocation\Time*.csv')
@1 as Number,
@2 as Name
[$(vFile)] (txt, codepage is 1252, explicit labels, delimiter is ';', header is 1 lines)
If there are no csv files there then nothing will be loaded without any error being generated.
View solution in original post
use the variable to capture the time and date.