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.

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