Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Please help with Concatenate/Group

coryanthony
8 - Asteroid

Hello,

 

Please help: I have several rows i need to group by [Entry Legacy Key] and concatenate. Please see files attached. Thank you

 

Output:

Output_sample.JPG

 

Input:

Input_sample.JPG

  

2 REPLIES 2
CoG
14 - Magnetar

What's the issue you're having? I am uploading a sample workflow, but please provide more specification as to what you're requirements are, if necessary.

2023-11-13_16-16_Concat.png

Prometheus
12 - Quasar

@coryanthony I think this is what you're looking for. If you want to concatenate a field and not have duplicate values in it, you need to get rid of duplicates. I used a Summarize tool to do it. Let me know how it works for you.

Concatenating Fields.PNG

Labels
Top Solution Authors