Copy data from above row when row is empty

Hi,

I am fairly new to Alteryx. I have been doing searches on this subject and I had tried different suggestions but they didn't work.

I have a PDF file I have extracted data from. In the PFD, the account # only shows for the 1st line of invoices the customer has. I need to copy down the account number to the blank item.

This is what I need for results.

Any help would greatly appreciated.

Workflow

Accepted answers

instead of isnull, use isempty and see if that works

Hi,

That worked! Thanks.

All comments

Please use Multi row formula tool to achieve the output.

Step 1: Input

Step 2:

IF ISNULL([Account])
THEN [Row-1:Account]
ELSE [Account]
ENDIF

Many thanks

Shanker V

Hi,

I didn't get any errors on the formula. However, the account # didn't copy down and remains blank.

instead of isnull, use isempty and see if that works

Hi,

That worked! Thanks.

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335