Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Repeat data in Null rows based on Page #

msjac01
7 - Meteor

Hi Alteryx users -

 

Does anyone have any advice on populating the null cells based on the above row for the the attached data set? I was attempting to use the multi-row tool but wasn't getting the desired results.

 

Thanks!

3 REPLIES 3
AGilbert
11 - Bolide

The expression for the multi-row tool should be "if isnull([Invoice Date]) then [row-1:Invoice Date] else [Invoice Date] endif". The multi-row tool only works on one field at a time. 

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @msjac01 ,

 

There may be a better way, but basically you can use Cross Tab Tool and Transpose Tool to apply Multi-Row Formula Tool to multiple columns.

I hope this helps. Good luck.

 

Workflow

1276207_Workflow.png

msjac01
7 - Meteor

Hi there,

 

I added this formula and attached are the before and after results. Looks like it doesn't like the 'Page' column

Labels
Top Solution Authors