How to append daily data in excel output

Question

Respectable All,

i have created a Alteryx workflow, which i will run daily and it will give daily basis data, i want the output in one excel in one single sheet but today's data should be paste below the yesterday's data, kindly help with the logic, i tried using append to existing sheet in output tool but its showing error (Error: Output Data (100): Incoming field named "DATE " cannot be appended. All incoming fields must match (or be mapped to) a destination field name.)

there is no specific range since the daily data is fluctuating.

Thank you :)

Anbumani · Answer

Hi agree with the solution however if i read the output file again and perform union, if the data is huge this will slowdown the workflow, please suggest any other possible solution.

Thank you so much

Raj · Answer

@Anbumani 
one work around is 
you can read the file and then union the new data and rewrite to the sheet
this will be easy and effective.

mark done if solved.