Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Multi row formula for multiple fields

Micheál
5 - Atom

In my dataset, I currently have 200 fields that I want to use the  same multi row formula on each field, is there a way to do this without using 200 multi row formulas for each field, thanks 

1 REPLY 1
echuong1
Alteryx Alumni (Retired)

You can pivot the data using a Transpose, use the Multi-row, and then pivot back with the cross-tab. In the multi-row you'd use a group by on the Name field.

 

Are you able to upload your workflow and data?

Labels
Top Solution Authors