Using Multi Row Formula To Fill with data in the row below

Question

I'm wanting to take a specific fields data and fill it with the details from the row below it. I'm using the multi row tool but receiving errors.

I believe I'm doing something incorrectly within the multi row tool but not sure what the issue is.

Example of what it looks like.

Shipment Schedule Ship Date21 15/18/20182 26/4/2017

What I want it to look like

Shipment Schedule Ship Date215/18/201815/18/201826/4/201726/4/2017

I'm working in the new version of Alteryx 2018.2

Capture.PNG

danrh · Accepted Answer

There are likely different ways to do this, but I would suggest reversing the order first, as the Multi-Row Formula tool works top to bottom:

neilgallen · Accepted Answer

@ashleyinman Make sure you have the formula options for "Group By" checked on the appropriate field. Then ensure that the dropdown for missing rows is set to "0 or empty"