Hi
select * into tablename_2023_12_12 from tablename
this query help us take backup of the table by appending todays date
now i want this query to be written in presql in output data tool but every time when i run the workflow backup table date should change to todays date
parllely i need to load my output data to that main table any soultions please
Hi @Ramcharan99, do you have any sample workflow you can share here that shows what you're doing? You can remove any confidential/sensitive data before sharing here. I previously shared with you a solution in this topic but I think it didn't help solve your issue.
If I can see the workflow of what you are doing with the data beforehand, I might be able to easily adapt the solution into it and be able to explain you in detail what you need to do after receiving the modified workflow.