Populate an excel template from 4 workflows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I want to populate fixed template (see attached) from 4 workflows that I have created in Alteryx.
See the highlighted cells in the template, they are to be populated from 4 sources.
Firstly I the column names in the workflow output and the template is different.
Can I populate this template using some mapping that this data will go into this cell?
some cells have multiple inputs in template from more than 1 workflow which needs to be summed up.
I know this is very complicated but can anyone help?
This template and the cell locations will never change so even a hardcode type solution will work.
- Labels:
- Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can define your Output tool to write to a specific cell range. The output tool also has an option to exclude the headers from being written so as long as you organize your columns beforehand, that could work.
The path in your output tool would look something like:
C:\path-to-template\excel-template.xlsx|||sheet1$AA26:AH52
Note the the setting in option 3 and 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for showing a way to do it but I have to output from multiple tables that I create in Alteryx to a single excel sheet.
And also one cell in the template could be a summation of values coming from the tables in Alteryx
For example: in my Template excel cell AA88 is to be populated by a sum of three values coming from 3 tables in my Alteryx workflow, and that will stay standard every time then how do I achieve that?
how do I achieve that?
