Use multi-row formula to copy down

[JamesG2806]

Use multi-row formula to copy down. I have attached my data here, what I want is where the customer is blank to copy the customer name down till it hits the next piece of entry then to copy that down so on and so forth. 

[estherb47 · Accepted solution]

Hi @JamesG2806 

Multi-row formula is the way to go!

Use this formula in the tool: IF IsEmpty([customer]) THEN [Row-1:customer]
ELSE [customer]
ENDIF

Let me know if that works!

Cheers,

Esther

[JamesG2806]

Spoiler

Hey @estherb47 

Thanks for the quick reply, works perfect thanks very much. One more question how would I then remove the rows where dates are empty from the equation. 

[estherb47]

You can always try a filter, using the null or empty option.

Cheers!

Esther

[lasmithfla]

I have similar problem but i have a more recent version of alteryx so looks a little different but my major issue is I don't see the ROW under the variables to select from and if I just type it in, I'm receiving an error