Join data from multiple rows into one.

[dlesny]

Hi I would really appreciate if someone could help. I am exploring Alteryx to Slack integration and I would like to input data from multiple rows into one.

From this:

name	value
text	Dhananjay please check Enabler: (BC12.7.532) Team-based Quality, as you have a mismatch with Team State
text	Dan please check Enabler: (BC11.11.286) Basic TDD/TestFirst, as you have a mismatch with Team State
text	Bob please check Enabler: (BC12.35.343) Force Ranked Prioritization, as you have a mismatch with Team State

To That:

name	value
text	Dhananjay please check Enabler: (BC12.7.532) Team-based Quality, as you have a mismatch with Team State Dan please check Enabler: (BC11.11.286) Basic TDD/TestFirst, as you have a mismatch with Team State Bob please check Enabler: (BC12.35.343) Force Ranked Prioritization, as you have a mismatch with Team State

Alternatively:

 How could this be improved to post to slack multiple lines? It is only posting last one atm.

[afv2688 · Accepted solution]

Hi @dlesny 

You can use the summarize tool for that.

Just group by 'name' and concatenate by value using < \n > as a delimeter (on the bottom part of the configuration)

Cheers

[dlesny]

Awesome, Thank you