Alteryx Designer Desktop Discussions

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

Make formula tool dynamic

Chirag_KRCPL
8 - Asteroid

Given below is the input data & desired output:


Chirag_KRCPL_0-1679572906686.png

 

My workflow is such that my fields will dynamically change based on the input data

 

So for example: Next time my data might have only Field1
                          Another time my data might have only Filed1 & Field2
                          Likewise at times my fields be even 4 or more

So I want to have this "Dynamic Sum" filed such that it runs the formula dynamically across whatever number of fields are introduced

2 REPLIES 2
binuacs
20 - Arcturus

@Chirag_KRCPL 

1. Transpose your data with key column as ID

2. use summarise tool - group by ID, sum of value

3. use join tool - join with ID as the key fields 

suby
11 - Bolide

Attached sample WF as suggested by Binuacs

Labels