Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Append and Overwrite data in hyper format with condition

NurulAtikah
8 - Asteroid

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.

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@NurulAtikah 
Do you have timestamp embedded in your workflow?

We need to judge when will be the near year.

NurulAtikah
8 - Asteroid

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.

 

Labels