topic Re: Store Calculated Value in QVD in Integration, Extension & APIs

Store Calculated Value in QVD

Wed, 08 Jun 2016 15:17:41 GMT

Hi,

I have a QVD with a dataValue (in the example the 'date as lastDateQvd').

I need to update this value with the date of today:

let dateNow = today(1);

[dateFromQVD]:

LOAD

date as lastDateQvd

FROM [$(Loadworkpath)data.qvd](qvd);

After the load there is some operation and at the end I hate to update the qvd with the $(dateNow) instead of the dataValue (in the example the 'date as lastDateQvd').

Re: Store Calculated Value in QVD

sunny_talwar — Wed, 08 Jun 2016 15:39:23 GMT

Where is the dataValue that you are referring to in your post above?

Re: Store Calculated Value in QVD

erikzions — Wed, 08 Jun 2016 15:43:42 GMT

I would just use the variable in your script.

let vDateNow = today(1);

[dateFromQVD]:

LOAD

'$(vDateNow)' as lastDateQvd

FROM [$(Loadworkpath)data.qvd](qvd);

Re: Store Calculated Value in QVD

Wed, 08 Jun 2016 15:49:47 GMT

Thanks for the support but I solved in this way: because of the qvd is composed by only a variable I replace the unique old data with the new one:

[tabUpdate]:

load replace(data,'$(dataLastUpdating)', '$(dateNow)') as data

FROM [$(Loadworkpath)data.qvd](qvd);

store [tabUpdate] into [$(Loadworkpath)data.qvd](qvd);