In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
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

Fill the null cells to the value above

Sshasnk
8 - Asteroid
‎12-23-2020 08:38 AM

I have a dataset where some of the rows is null and I have to put the value which is above

 

Input:

Field1
AXLSKDFI239848
 
ALSKC4839230
 
 
SLKCIV3847390
XLKDIEO384930

 

Output:

Field1
AXLSKDFI239848
AXLSKDFI239848
ALSKC4839230
ALSKC4839230
ALSKC4839230
SLKCIV3847390
XLKDIEO384930

 

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

5 REPLIES 5
christine_assaad
Alteryx
Alteryx
‎12-23-2020 08:46 AM

Hi @Sshasnk 

 

Please check Multi row tool and the attached. Hope it helps. Cheers!

 

christine_assaad_0-1608742004018.png

 

Multi row.yxmd
Reply
Emil_Kos
17 - Castor
17 - Castor
‎12-23-2020 08:50 AM

Hi @Sshasnk,

 

Please see the solution attached.

Emil_Kos_0-1608742171571.png

The multi-row is the perfect tool for a situation like this.

 

Good luck!

Multirow.yxmd
Reply
tingho100
5 - Atom
‎12-14-2023 05:55 PM

Hi all,

Any way to apply this function to multiple columns without creating a lot of Multi row tool?

Thanks

Reply
0 Likes
flying008
15 - Aurora
‎12-14-2023 07:18 PM

@tingho100 

 

FYI.

录制_2023_12_15_11_17_38_686.gif

Reply
salmansadatkarim
5 - Atom
‎11-12-2024 09:52 AM

By any chance can you please share this workflow?

Reply
0 Likes
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All