How to increment number based on the previous value

Question

Hi Team,

I am looking for a solution in Alteryx designer. I want to increment the value in ID column based on the available number. can someone please advise?

Input

CustomerIDC128C2 C3 C4 C5

Required Output

CustomerIDC128C229C330C431C532

Luke_C · Accepted Answer

Hi @akanchar

You could use a multi-row formula tool. See below, if the ID field is blank it looks to the previous row's value and adds 1.