Free Trial

Alteryx Designer Desktop Discussions

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

App Input and Summarize toAaccount for Various Number of Fields

rsidani
6 - Meteoroid

I have a workflow that requires I do a summarize on each of the fields on the input tool.  So if there are 4 fields on the input, I need four summarize tools.  My challenge is that I need to make this an application for the broader organization.  In their input file, it could have between 2 and 10 fields.  I am looking for ideas on how to make the app dynamic to control for mapping a various number of fields in the input and the subsequent number of summarize tools.  My thoughts so far are around making containers for each possible number of fields and then enabling/disabling with condition,  using detours, dynamic inputs, other conditional formulas.  I’m looking for best practice on this.

 

Alteryx_input.jpg

2 REPLIES 2
SeanAdams
17 - Castor
17 - Castor

Hey Rsidani,

I think that you can achieve this in an easier way by doing a transpose before summarize - that gives you pretty much what mentioned below, but works with any number of columns

2017-06-25_21-41-38.png

rsidani
6 - Meteoroid

Totally right!  Thank you.

 

Robert

Labels
Top Solution Authors