Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Discussions

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

Create a statement using ids

Nikhil9403
6 - Meteoroid

Hi, guys need your help with one of the questions here. The first 2 columns have ids, and the last column has text. A sentence is to be created using those Ids.

 

I have attached sample data for your reference. 

2 REPLIES 2
ed_hayter
12 - Quasar

If the desired Output is the last two records of the dataset this can be achieved by sorting on sequence order and then using a summarize tool to concatenate the text field - grouped by the ID to keep them on separate lines

 

Concatenate strings WF.png

messi007
15 - Aurora
15 - Aurora

@Nikhil9403,

 

Plase see below :

 

Capture.PNG

 

Attahed the workflow.

Regards

Labels