Append and Overwrite data in hyper format with condition

Question

Hi everyone,

I'm looking for a solution to solve my biggest problem right now.  I need to output my data into hyper format however I have a problem generating output that meets my condition.

Every month I will run my workflow and will overwrite data in hyper but when the new year coming instead overwrites the output need to append to make sure the data for last year still exits in the same hyper.

I really hope to get a solution to solve my problem.

NurulAtikah · Answer

Hi Qiu,

Yes, I have timestamps in my workflow.
Currently my input data in excel. Every month data will append and save as a different excel file, therefore, I need to overwrite my output in hyper but once a new year coming, the input in excel does not carry last year's data.
From this, I need to do overwrite without lost last year's data that already been run.

Qiu · Answer

@NurulAtikah 
Do you have timestamp embedded in your workflow?

We need to judge when will be the near year.