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.

[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!

[Yoshiro_Fujimori]

Hi @anhnguyenngoc2002 ,

I would recommend you transpose the table as it is much easier to treat data on Alteryx.

And if you always delete the oldest one month data and add a new one month data, you can do it as below.

Workflow

Old Data

New Data

Output

I hope this can be of some help.

[anhnguyenngoc2002]

Hi. Although this is not appropriate solution but with your help, I think I have some tools needed to try with my workflow. Thank you so much!

[anhnguyenngoc2002]

thank you so much for your help!

[Yoshiro_Fujimori]

Hi @anhnguyenngoc2002 ,

In case you really need to work on columns rather than rows, this might be a solution...

Workflow

When you import / export the data, you need to treat the 1st row as data, not column name, as below;

Input Data tool configuration

Output Data configuration