We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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

Fill in null values in a row with value in a later column

wonka1234
10 - Fireball
‎01-09-2023 02:41 PM

Hi,

 

I have a large dataset with data like this:

 

Delegate1Delegate2Delegate3Delegate4Delegate5Delegate6Delegate7Delegate8Delegate9
Louis.Stevens@hotmail.com       
Louis.Stevens@hotmail.com   Louis.Stevens@hotmail.com  
Louis.Stevens@hotmail.com     Louis.Stevens@hotmail.comLouis.Stevens@hotmail.com
Louis.Stevens@hotmail.com     Louis.Stevens@hotmail.comLouis.Stevens@hotmail.com

How can I shrink this dataset to something like this:

 

Delegate1Delegate2Delegate3Delegate4Delegate5Delegate6Delegate7Delegate8Delegate9
Louis.Stevens@hotmail.com       
Louis.Stevens@hotmail.comLouis.Stevens@hotmail.com      
Louis.Stevens@hotmail.comLouis.Stevens@hotmail.comLouis.Stevens@hotmail.com     
Louis.Stevens@hotmail.comLouis.Stevens@hotmail.comLouis.Stevens@hotmail.com     

 

 

please note that this email could be any email, not just the one person.

 

Thanks.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

11 REPLIES 11
Felipe_Ribeir0
16 - Nebula
‎01-09-2023 04:48 PM

@wonka1234 

 

Another thing, the tile tool was with a config that possibly could cause issues with more data. try to change it to be like this:

 

Felipe_Ribeir0_0-1673311627836.png

 

Reply
0 Likes
Felipe_Ribeir0
16 - Nebula
‎01-09-2023 04:52 PM

@wonka1234 

 

Try this version

 

Felipe_Ribeir0_0-1673311967412.png

 

Fill in null values in a row with value in a later column.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All