Data to be displayed as a List

[vishwakar]

Hi All

I am having data in the format

View_id	Group_name
1	Name
1	Beta
1	Alpha
1	Testers

and I am looking for the output to be in single row 

View_id	Group_name
1	Name,Beta,Alpha,Testers

Looking for help on using the right tool for obtaining the results.

Thanks for your help

Thanks

Vishwanath

[MarqueeCrew]

1. Add a field using a formula tool named header and put "Group_name" as a constant value.
2. Use a crosstab tool and your key is view_id. Your header is "header" and your "data" field is group_name. Your method is concatenation.

http://help.alteryx.com/10.0/index.htm#CrossTab.htm?Highlight=Crosstab

Thanks,

Mark

[s_pichaipillai · Accepted solution]

Another option would be 

you can use the Summarize tool to bring this list using concatenation by grouping View_id.

 

[MarqueeCrew]

I like that idea more. So many ways to solve a problem. 

[vishwakar]

Thanks  MarqueeCrew  ,s_pichaipillai for helping me.

Thanks

Vishwanath

[vishwakar]

Hi

View_id	Group_Name
1	Name
1	Beta
1	Alpha
1	Testers
1	Name
1	Alpha

I have duplicates in my data and I want to get the group name only once and I want the output to be displayed

View_id	Group_Name
1	Name,Alpha,Testers,Beta

Thanks for the help

[MarqueeCrew]

First you could unique the data on viewid and group name. Then use the summarize by concatenation solution.