Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Denver, CO

Welcome to the Denver User Group

Click in the JOIN GROUP button to follow our news and attend our events!

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.

3 REPLIES 3
PhilE
5 - Atom
ChristinaFPE
7 - Meteor

There are a few different ways you can do this.

 

Output to specific cells:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Writing-to-a-specific-cell-in-Excel/td...

 

Or you can create a named range and output to there:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-Output-to-Named-Range/td-p/45491

 

 

We use SAP as well and what I ended up doing was bringing the top 6 rows of the SAP journal entry template into Alteryx with an input tool, then, using a union tool, I set the Output Order to have the template first and the data below that. This will append your journal entry data below the first 6 rows of that template. Then I use a Dynamic Rename to remove the Alteryx designated column headers.

 

SAP_JE_Upload.JPG

 

 

 

 

TonyaS
Alteryx
Alteryx

@offerdan you might find this video helpful as well: Parallel Block Until Done Alteryx Macro

 

It shows how to easily output data to first one tab and then another without errors about the file already being in use. 

Tonya Smith
Sr. Technical Product Manager, cloud App Builder