Replacing data on one row, with the information from the row above

[DaleN24]

Hello 

I have data imported to Alteryx with the following detail

Account	Description	Debit	Credit
966	Called up share capital
/1	Share capital		1
968	Profit and loss account
/1	Brought forward	326102.3

In the account column, where the detail is shown as "/1" i need to replace that with the data from the row above in each case. This affects multiple lines but in every case just requires that data to be replaced with the data from one row up in the same column. 

It can also be different numbers such as "/2" or "/3", which isn't determined by the number above.

Is this something simple to do in Alteryx with a formula or tool im unaware of. The replace tools appear to require a second input showing what to replace the data with, which wouldn't work in my case.

[DavidP · Accepted solution]

Hi @DaleN24 

You can use a multi-row formula tool to update [Account] with the following formula:

if contains([Account],"/") then [Row-1:Account] else [Account] endif

[DaleN24]

Thanks David

That works great