Hello!
I have a question - After grouping, could we concat the data in the same group into the same cell?
Below is an example to illustrate my question, do we have a method to automate it in Alteryx? Thank you!
Before data manipulation | After data manipulation | |||||
Department | Year | Employee | Group | Employee | ||
A | 2020 | Nancy | A-2020 | Nancy | ||
A | 2019 | Joe | A-2019 | Joe, Nancy | ||
A | 2019 | Nancy | B-2020 | James | ||
B | 2020 | James | B-2019 | Adam, James, Brenda | ||
B | 2019 | Adam | ||||
B | 2019 | James | ||||
B | 2018 | Brenda |
Solved! Go to Solution.