Free Trial

Alteryx Designer Desktop Discussions

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

multi row tool help - If person belongs to > 1 group then call those out

wonka1234
10 - Fireball

Hi,

 

I need to come up with a multi row or formula tool to get this logic -

 

SegmentNameLogic Result
USLouis StevensIf Name belongs to > 1 Segments then show them.US, CAN
CANLouis Stevens US, CAN
USRen Stevens blank or ''
USSteve Stevens 

blank or ''

 

does anyone know how I can accomplish this?

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

Hi @wonka1234 I came up with a approach using a summarise tool to concantenate your data and then join back onto the orginal data. I've attached a workflow demostrating this approach.

 

Group_03092023.JPG

geraldo
13 - Pulsar

@wonka1234 

 

For this simple case I would use the summarize tool.

but if it is more complicated we can build one with multirow

wonka1234
10 - Fireball

@geraldo  thanks, this looks to be working . However if there is multiple US rows for Louis Stevens then the result could be like US , US , CAN . I want these to be distinct/unique.

geraldo
13 - Pulsar

@wonka1234 

 


A summarize tool can be placed beforehand.
Certainly in multirow tools putting it as a group will make it easier but the concatenation formula will be more complicated;
follow a workflow with the adjustment of distinct

Labels
Top Solution Authors