Alteryx Designer Desktop Discussions

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

question on multi row tool

chritinepwc
6 - Meteoroid

I have the data below. 

image 1.PNG

I need row 2-5 to be 017 and row 7-8 to be 088. 

I used multi-row function

image 2.PNG

but the result is as below. 

image 3.PNG

Why is the formula only applying to one row only? How to fix it? Thank you! 

2 REPLIES 2
patrick_digan
17 - Castor
17 - Castor
Change [row-1:number] to [row-1:newfield]. That should do the trick!
chritinepwc
6 - Meteoroid

Exactly! This is amazing! Thank you! 

Labels