Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Multi Row Formula

sebenciven
8 - Asteroid

Good morning,

I would like to find a way to be able to calculate the key field. This must be composed by the concatenation of the fields that have FLAG = 'C'. The computed key will have to be the same for all rows and change when a new set of rows with FLAG = 'C' reoccurs. In the first image the data set, in the second image the result I would like to obtain. The fields with FLAG= 'C' may vary in numerosity.

Thanks to everyone!

 

1 REPLY 1
binuacs
21 - Polaris
Labels
Top Solution Authors