identifying occurrences of string

Question

I am new to Alteryx so hope it is okay to ask this question.  The result I would like to get in the example below, is, for each member, what teams they are a member of.  I believe it have to do text to string and transpose, but am unsure of how to arrive at the result I need.  Thank you.

test.xlsx

T_Willins · Accepted Answer

Hi @rheep,

You are in the right forum to ask these questions.  While there are different ways to do this, I find the Summarize tool works well for concatenating data.

grazitti_sapna · Accepted Answer

Hi @rheep , alternate solution.

Thanks.

rheep · Accepted Answer

Thank you so much!