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.
fireworks

Retain values in a row after adding another one

AngeloBen25
5 - Atom

Is there a way where I put another value in Sample 2 column then that value will be placed in last row.so that its record id will be 5. Sample.JPG

 

The summarize tool sort the values in Sample 2 alphabetically. What I want to have is when I put for example "Alright" in Sample 2 column, it will be placed in row 5 with Record ID 5.

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@AngeloBen25 
How will you add the data record "Alright"? 
Input tool and union?

AngeloBen25
5 - Atom

In the input tool

akhavea2190
5 - Atom

Use the input tool and use union to add rows to your data

nagakavyasri
12 - Quasar

Screenshot 2023-06-27 163248.png

Labels
Top Solution Authors