topic Deleting and updating data in App Development

Deleting and updating data

Sasi3557 — Sat, 16 Nov 2024 19:55:20 GMT

Hi qliksense experts

I have incremental data with only month specified. I need to delete the last 30 days data and update all the data including present date.

lets say i have data till today(2019/09/11). As i dont have the date specified and its last 30 days data to be deleted and updated. If the present date is <30 i need to delete the last month data till present data and update till present date again.

any ideas.

Re: Deleting and updating data

jerifortune — Thu, 10 Oct 2019 15:26:58 GMT

In your script, create a variable

LET vLast30Days= Date(now(1)-30);

On your script

LOAD...................
WHERE ORDERDATE < '$(vLast30Days)'

Try to ensure that ORDERDATE and vLast30Days are in the same date format

Re: Deleting and updating data

Sasi3557 — Thu, 10 Oct 2019 15:35:33 GMT

but i don’t have the order date in my table i only have the month. So if its 15 of this month and if i load the data tomorrow it should delete last months and present month data and load all the data till tomorrow as the data would change depending on the trigger 30 days /20 days

Re: Deleting and updating data

jerifortune — Thu, 10 Oct 2019 15:39:15 GMT

I used order date as an example. Do you have a date column? OR Do you have only month and year?

Re: Deleting and updating data

Sasi3557 — Thu, 10 Oct 2019 15:40:44 GMT

I have month column and year column thats it.

Re: Deleting and updating data

jerifortune — Thu, 10 Oct 2019 15:45:45 GMT

WHERE

Date(Monthend(makedate([Year],[Month]))) < '$(vLast30Days)'