topic Re: Dynamic naming by date when storing in QlikView

Dynamic naming by date when storing

Wed, 25 Nov 2020 16:16:04 GMT

Hey guys,

I have made a SQL script that I have scheduled daily in the QMC for it to auto generate a daily file.

The syntax is as you might now between getdate()-1 and getdate(). I store this file as a CSV file in the script, and I want it to add the date aswell in the name.

_$(vL.Client)_day.csv (txt, delimiter is ';');

Re: Dynamic naming by date when storing

swuehl — Tue, 15 Mar 2016 10:45:49 GMT

Maybe like

Let vToday = Today();

...

_$(vL.Client)_$(vToday).csv (txt, delimiter is ';');

Re: Dynamic naming by date when storing

Tue, 15 Mar 2016 11:38:24 GMT

Thansk a lot!