We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
13 - Pulsar

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
Top Solution Authors