Alteryx workflow for Excel

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!

Output

Macros

Optimization

Chained App

Power BI

Accepted answers

andyuttley

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

All comments

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703