Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Alteryx workflow for Excel

lksfe_10
5 - Atom

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!

 

 

4 REPLIES 4
andyuttley
11 - Bolide
11 - Bolide

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
5 - Atom
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
11 - Bolide
11 - Bolide

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
5 - Atom

hey @andyuttley

 

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

 

Thank you in advance!

 

Labels