Populate an excel template from 4 workflows

rohin92

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

See the 3 attached screenshots.

Pivot Table 1 and 2 are Alteryx outputs and numbered from 1 to 4 column wise.

Template is the excel I need to populate. I have highlighted the row of "United Kingdom" in the template as an example, I need Column "AE" to be populated by a sum of columns marked as "1" in both tables, Column "AF" by a sum of columns marked as "2", so on and so forth.

Please guide me.

Template.PNG

Pivot Table 1.PNG

Pivot Table 2.PNG

lwolfie

What is the timing of when the workflows are run?  Could you output to separate files and then create a separate workflow that takes those outputs as inputs and combines them into one table?  The summing of multiple inputs is the difficult part.  Otherwise, you could output to a selected range.  When you select excel as the output, under the Specify a sheet is a checkmark to Specify a range.