General Discussions

Discuss any topics that are not product-specific here.

Populate an excel template from 4 workflows

rohin92
6 - Meteoroid

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.

1 REPLY 1
caltang
17 - Castor
17 - Castor

Yes, you can populate them. But, you have too many headers. You'll need to simplify your output and how it looks.

 

In addition, try posting to the Designer Desktop forum rather than the General forum. When you post, kindly input some sample data, and provide an expected output + with nice-to-haves in your request. 

 

But what you're asking for is a full build (end to end). The community can guide you, but not build end to end for you.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels