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

[wonka1234]

Hi,

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

Segment	Name	Logic	Result
US	Louis Stevens	If Name belongs to > 1 Segments then show them.	US, CAN
CAN	Louis Stevens		US, CAN
US	Ren Stevens		blank or ''
US	Steve Stevens		blank or ''

does anyone know how I can accomplish this?

[JosephSerpis]

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.

[geraldo]

@wonka1234 

For this simple case I would use the summarize tool.

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

[wonka1234]

@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 · Accepted solution]

@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