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