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
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels