Integration, Extension & APIs

[#1]

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').

[sunny_talwar]

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

[erikzions]

I would just use the variable in your script.

let vDateNow = today(1);

[dateFromQVD]:

LOAD

  '$(vDateNow)' as lastDateQvd

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

[#4 · Accepted solution]

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);