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.
Need a help to resolve the below issue.
We have one excel with an extension of YYYYMM as source for our application.
When ever there is an update in excel, the excel will be renamed as Excel_YYYYMM with updated month and year.
Please help me to load the excel automatically, without changing the script every time.
Thanks in advance.
You can do this, then you will fetch all excelfiles with the name format 'Excel_XXXXXX.xlsx'
[Excel_??????.xlsx] (ooxml, embedded labels);
If you only need to read the current YYYYMM file you can do like this:
LET vL.CurrentYearMonth = date(today(),'YYYYMM');
[Excel_$(vL.CurrentYearMonth).xlsx] (ooxml, embedded labels);