Alteryx Designer Desktop Discussions

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

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

offerdan
6 - 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.

 

 

2 REPLIES 2
MichalM
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...
offerdan
6 - Meteoroid

Thank you! This should do the trick.

Labels