If i understand well, you have one table by day ?
so , you can do with ADD Load and Partial Reload (CTRL+SHIFT+R).
But if you want to introduce a loop maybe the best way is to create a QVD file :
1) read QVD of your data
2) read new data for the current day,
3) set the data thanks to Add Load
4) Update your QVD
look at the reference manual to understand how to create a QVD file
Thank you for this, i can now create a qvd file and add to it on a daily basis. The final thing i need is to add a field to the qvd file that includes the date that the record is added to the qvd file?
I've tried doing this by setting a variable of Today() and loading this variable as the extra field
ThisExecTime = Today();
"FK_Status" AS Status,
"FK_Status" NOT LIKE
But i get an error saying the field does not exist. :(