General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Help with Multirow funtion

J_SS
5 - Atom

Table Input is the current data set, I am trying to create an extra column in the output table. If [RecordID] == 1 Then 1
Elseif IsNull([RecordID]) or [RecordID] <= [Row+1:RecordID] Then [SetID] + 1
Else [SetID] endif

 

Input
RecordIDColumn 1Column 2
1aa123
2ab345
3ac123
4ad234
5ae234
1aa123
2ab345
3ac123
4ad234
5ae234
1aa123
2ab345
3ac123
4ad234
5ae234

 

 

output
RecordIDColumn 1Column 2SetID
1aa1231
2ab3451
3ac1231
4ad2341
5ae2341
1aa1232
2ab3452
3ac1232
4ad2342
5ae2342
1aa1233
2ab3453
3ac1233
4ad2343
5ae2343

 

 

 

1 REPLY 1
caltang
17 - Castor
17 - Castor

You can use the Tile tool to achieve this without Multi-row tool.

 

image.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors