Multi-row formula or alternative - flagging multiple rows at the same time.

[dbmurray]

Hi community!

I'm a bit stuck - call it  an "Alteryx Block"

I've got a dataset like this:

ID	NAME	TEAM	ROLE
1	John Smith	Team A	Salesperson
1	John Smith	Team A	Manager
2	Sarah Teal	Team A	Salesperson
2	Sarah Teal	Team B	Manager
3	Peter Pan	Team C	Salesperson
3	Peter Pan	Team C	Designer
4	Helen Troy	Team E	Manager
4	Helen Troy	Team F	Designer
5	Mary Ritter	Team B	Manager
5	Mary Ritter	Team B	Salesperson

I want to be able to flag if a person works in two different teams. I know I can do this using multiple multi-row formulas, but hoping to make something super clean/efficient. 

Here is what I've got thus far in my multi-row formula based on this data for a new field called 'Same Team?' (grouped by ID) (see attached workflow).

If [ID]=[Row+1:ID] AND [TEAM]=[Row+1:TEAM] THEN "Same Team" ELSE "" ENDIF

This is the output from this tool. Note I'd like to also flag the cells marked in YELLOW with the string 'Same Team' as well - hopefully in one tool.

Wondering if anyone had a more efficient way of doing this?

Cheers in advance

D

[binuacs · Accepted solution]

@dbmurray one way of doing this

[dbmurray]

Thank you so much @binuacs - that worked perfectly!!