Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How replace current row value with next row value for a particular coumn ?


I have an excel sheet sourcedata on which i have to column specialty and Role. when the specialty is 'Total' i want to replace the value of Role with next row.

e.g If specialty ='Total' and Role ='Consultant' then i want to replace this Consultant with the next value.

if the next row has Role='SAS Doctors' then the result would be specialty ='Total' , Role='SAS Doctors' 


Please find attached excel sheet for reference.


Thanks in advance.


Hi @shukla_sumit, I think this can be solved with a multirow formula tool using the formula "IIf([Specialty]="Total", [Row+1:Role], [Role])". This is what I came up with.




+1 to @JoBen's suggestion