Alteryx Designer Desktop Discussions

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

How to append daily data in excel output

Anbumani
7 - Meteor

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 :)

2 REPLIES 2
Raj
16 - Nebula

@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.

Anbumani
7 - Meteor

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

Labels
Top Solution Authors