Populate an excel template from 4 workflows

Question

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.

Template.PNG

rohin92 · Answer

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?

jrgo · Answer

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