topic Excel with date extension in QlikView

Excel with date extension

bhargavikn — Sat, 16 Nov 2024 03:04:38 GMT

Hello,

Need a help to resolve the below issue.

We have one excel with an extension of YYYYMM as source for our application.

Example: Excel_201905.

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.

Vegar — Mon, 08 Jul 2019 07:20:09 GMT

You can do this, then you will fetch all excelfiles with the name format 'Excel_XXXXXX.xlsx'

Data: LOAD * FROM [Excel_??????.xlsx] (ooxml, embedded labels);

Vegar — Mon, 08 Jul 2019 07:22:56 GMT

If you only need to read the current YYYYMM file you can do like this:

LET vL.CurrentYearMonth = date(today(),'YYYYMM'); Data: LOAD * FROM [Excel_$(vL.CurrentYearMonth).xlsx] (ooxml, embedded labels);