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
Solved! Go to Solution.
Another option would be
you can use the Summarize tool to bring this list using concatenation by grouping View_id.
I like that idea more. So many ways to solve a problem.
Thanks MarqueeCrew ,s_pichaipillai for helping me.
Thanks
Vishwanath
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