Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sequences of rows based on a value

w_zielinski
5 - Atom

Hey guys,

I'm struggling with creating sequences based on value. Let me provide you an example:

w_zielinski_0-1650463049246.png


From this table I would like to create two tables with different row sum, so first table would consist of records 1,2,4; second of rows 1,3,4. Based on the row sum I need to have unique values of row_sum but instead of excluding that duplicate value of dataset I need to create another table with that. Is there a way to do that in Alteryx? I need to do that for 15 values.

1 REPLY 1
soccertil1108
8 - Asteroid

I am not sure if this represents the complexity of your total problem, but the workflow shows how to split, find the subtract with a join and then regroup into two data streams.

 

soccertil1108_0-1650465554378.png

 

Labels
Top Solution Authors