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.
Solved! Go to Solution.
Hi @Whooppee
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.