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