Help creating a qvds into Yearly-monthly folders in an automated refreshed qvw daily

[rt_new_user]

I need help please with the load script creating a qvd file. The qvd file should be created daily as the app gets reloaded daily automatically. 

My data source is a webfile i am scrapping in a csv format: challenge with that is that it doesn't have any date field in it. when even you read the file it will give you last 24 hours data. therefore in my load script i used this:

Let vToday = Today();

JHT:

LOAD

'$(vToday)-1' as Date_JHT,
country as Country_JHT,
count as Count_JHT

FROM
[http://voiptools.in.telstra.com.au/wi3s/regv2/vowifioverseas.php?output=csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

This does the trick however i plan to run this script everyday and want to create a qvd for each day in year folder-.month folder which has all the dates for that month.

How do i go about this please?

[MayilVahanan · Accepted solution]

HI @rt_new_user 

try like below

Let vYear = Year(Today()-1);

Let vMonth = Month(Today()-1);

Let vDate = Date(Today()-1 ,'YYYYMMDD');

JHT:

LOAD

'$(vDate)' as Date_JHT,
country as Country_JHT,
count as Count_JHT

FROM
[http://voiptools.in.telstra.com.au/wi3s/regv2/vowifioverseas.php?output=csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

store JHT into urrootfolder/$(vYear)/$(vMonth)/JHT_$(vDate).qvd(qvd);

for ex: if you load the app today, Daily qvd stored into urrootfolder/2020/dec/JHT_20201214.qvd .

Hope it helps

[rt_new_user]

Thanks for your help. It works like a charm 🙂