We use local storage to store our master tables for capacity reporting. These tables are appended to each month giving us a two year timesscale to trend across.
At the moment these tables are getting quite big so it would be good to trim old data out of them.
I have a delete query with a where statement simply saying ‘between A and B dates’
I have been trying to set up a loop data set to step through each table and delete any old data but I’m struggling with the correct syntax to use the loop dataset variable as a table name
Anyone already done this that can help?