community
cancel
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 ?

Highlighted

@jdunkerley79

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.

Bolide

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.

 

Help1.PNG

Quasar

+1 to @JoBen's suggestion

Labels