community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Can Alteryx output data to a particular cell/cells in Excel?

Meteoroid

I am hoping to output data from Alteryx into a particular cell or cells in Excel.

 

We have specific journal entry templates in our Finance Dept to upload into SAP. Is there a tool that i am not aware of that will assist with this? I could have Alteryx export to a new tab in our workpaper and then use Sumifs to populate the entry but I would prefer to have Alteryx generate the entry onto our template.

 

 

Alteryx
Alteryx
Alteryx will allow you to output into either a specific range or a named range within Excel using the Output data tool. Here's one of the posts on how to achieve it

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-a-specific-range-in-Excel/td...
Meteoroid

Thank you! This should do the trick.

Labels