Multi row formula for multiple fields
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Micheál
5 - Atom
12-01-2020
09:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Expression
1 REPLY 1
echuong1
Alteryx Alumni (Retired)
12-01-2020
10:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
