Pre Sql in output Date

Question

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

NeoInfiniTech · Answer

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.