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

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Multi-row formula - Duplicate a value in the middle

lolwat12345
6 - Meteoroid

Hello, I have a dataset like this

Multiplier
0
0
0
0.75
0
0
0.5
0

 

I need to convert it to this:

Multiplier
0.75
0.75
0.75
0.75
0.5
0.5
0.5
0

Could anyone help suggest a formula please, tks

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

Hi @lolwat12345 

 

Filling values upwards is trickier than filling down. For this I usually add a record ID, sort the data to reverse the order, do the multi-row, and sort back:

 

image.png

Labels
Top Solution Authors