Hi All I am having data in the format View_idGroup_name1Name1Beta1Alpha1Testers and I am looking for the output to be in single row View_idGroup_name1Name,Beta,Alpha,Testers Looking for help on using the right tool for obtaining the results. Thanks for your help Thanks Vishwanath

Data to be displayed as a List

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

Transformation

Preparation

Accepted answers

s_pichaipillai

Another option would be

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

All comments

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

Another option would be

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

MarqueeCrew

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703