topic Re: Store file once a week in QlikView

Store file once a week

maasool — Sat, 16 Nov 2024 20:49:51 GMT

Hello dear Qlik Community,

During data load it is possible to store files on drives. Every time data is loaded, file is stored.

'store DATA into 'lib://P-QLIK/data.csv'(txt,delimiter is ';');'

Is it possible to store file only once a week (for example only on Wednesdays)? How to write this in code?

Thanks
maasool

lironbaram — Tue, 21 May 2019 07:01:00 GMT

you can do something like

if weekday(today()) = 2 then ///counting start from zero for monday in default mode

store DATA into 'lib://P-QLIK/data.csv'(txt,delimiter is ';');

end if

bramkn — Tue, 21 May 2019 07:01:31 GMT

if weekday(today()) = 3 then (weekday can start at different days so might be 2).
store ..............
end if

maasool — Tue, 21 May 2019 09:25:03 GMT

Thank you both!