community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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

@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