In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi-row formula - Duplicate a value in the middle

lolwat12345
6 - Meteoroid
‎04-19-2024 07:39 AM

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

Labels:
Reply

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
binu_acs
21 - Polaris
‎04-19-2024 08:04 AM

@lolwat12345 One way of doing this

image.png

Duplicate_Value_19042024.yxmd
Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All