Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
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
Free Trial

Alteryx Designer Desktop Discussions

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

How to copy value from first row and past it into all the rows below

Sshasnk
8 - Asteroid
‎07-08-2020 06:08 AM

Input: 

Time
112611
112611
112612
112612
112613

 

Expected output:

Time
112611 
112611 
112611 
112611 
112611 

 

I am trying to copy the value from first cell to all cell below

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
marcusblackhill
12 - Quasar
12 - Quasar
‎07-08-2020 06:14 AM

Hello!

 

I think you can put a record ID and use a multi row formula, where if the ID is 1 you put the value of the row, else put the value of the row above, look my example.

Example .yxmd
Reply
0 Likes
Kenda
16 - Nebula
16 - Nebula
‎07-08-2020 06:16 AM

Hi @Sshasnk 

 

You could use a Multi-Row Formula here with this expression:

[Row-1:Time]

 

Don't forget to set the drop down in the configuration to "Set to Values of Closest Valid Row" as shown:

 

Kenda_0-1594214178839.png

 

Reply
Sshasnk
8 - Asteroid
‎07-08-2020 06:24 AM

Perfect !!

Reply
0 Likes
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels