Alteryx workflow for Excel

[lksfe_10]

Hello,

is it possible, with an Alteryx workflow process, to update an excel file and put the updated data into another excel file?

So that I just run the workflow and this process will happen. The best version would be if this process happen automatically every night.

Thank you for your help!

[andyuttley]

Hi @lksfe_10 

Yes, this is all possible! You can input and output to one or multiple files within a workflow (including xlsx). If you wanted to automate this process you would need Alteryx Server to schedule it - in Designer you'd have to manually kick off this process yourself. 

Hope that helps

Andy 

[lksfe_10]

Hey @andyuttley, thank you for your reply. I want to transfer just the updated rows, not the whole file, into another excel file. Do you know how this works? Best wishes Lukas

[andyuttley · Accepted solution]

Yes, if it's unknown which rows might have changed, then I'd just compare my rows in the file at the start of the workflow with those at the end (using a join); anything that comes out the Left/Right would be a row that has had a change in it - just this flow of data could then be sent to output. 

Hope that makes sense - happy to send over an example if you prefer?

Andy 

[lksfe_10]

hey @andyuttley

that makes sense, thank you! yes, an example would be perfect!

Thank you in advance!