Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

A use of multi-field formula?

chrissgtan
7 - Meteor

Hello Alteryx community, any tips to use the multi-field formula (or any other way) so create the output like below, please?

I have attached the Excel file for your reference.

Thanks a million

 

chrissgtan_0-1657735921307.png

 

4 REPLIES 4
Emmanuel_G
13 - Pulsar

@chrissgtan ,

 

Do you want something like this ?

Emmanuel_G_0-1657740854806.png

 

Brian32
8 - Asteroid

You could try something like this.  Would be able to run every week without any type of update to the workflow.  Attached is the workflow.

Brian32_0-1657743574435.png

 

chrissgtan
7 - Meteor

Ingenious, thanks @Emmanuel_G  .. I learned a new way to use the multi-row tool :-)

chrissgtan
7 - Meteor

Ingenious, thanks @Brian32   .. I learned how to do this without the multi-row/field tool. Also being able to this in "auto" fashion is an icing on the cake :-)

Labels