Use this group to build a community of Alteryx Users in the Denver, CO area. It is open to all who are already Alteryx users or want to explore the capabilities of Alteryx Advanced Analytics Platform. Ask questions, share ideas and best practices related to Alteryx analytics platform.
Denver User Group Leaders:
Find tips to make the most of your User Group experience.LEARN MORE
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.
Solved! Go to Solution.
There are a few different ways you can do this.
Output to specific cells:
Or you can create a named range and output to there:
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.