Append result to existing excel sheet in Alteryx

anhnguyenngoc2002

Hi everyone,

I'm starting using Alteryx to do monthly reports. I have a template output below. What I calculate every month is Target and Complete. I want to keep last month's data and update new month result into the next right column. 

How can I do this in Alteryx?

Thank you for your help.

Annotation 2023-05-11 105949.png

FinnCharlton

Hi @anhnguyenngoc2002 ,

I recommend importing the old table, appending the new data to it, then overwriting the old Excel with the new appended version. Something like this:

Hope this helps!