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 02:49 PM

Hi @wonka1234 

 

One way of doing this

 

Felipe_Ribeir0_0-1673304527680.png

 

Fill in null values in a row with value in a later column.yxmd
Reply
Qiu
21 - Polaris
21 - Polaris
‎01-09-2023 03:15 PM

@wonka1234 
Definitely note a better one but just try something different. 😁

0110-wonka1234.PNG

0110-wonka1234.yxmd
Reply
wonka1234
10 - Fireball
‎01-09-2023 03:48 PM

@Felipe_Ribeir0 i forgot to mention i have other columns before these delegate columns and they are not showing up as null. anyway to not do this?

Reply
0 Likes
Felipe_Ribeir0
16 - Nebula
‎01-09-2023 03:58 PM

@wonka1234 

 

Something like this? You have some columns that you want to keep

 

INPUT

Felipe_Ribeir0_0-1673308531036.png

 

OUTPUT

Felipe_Ribeir0_1-1673308605277.png

 

 

 

 

Fill in null values in a row with value in a later column.yxmd
Reply
wonka1234
10 - Fireball
‎01-09-2023 04:24 PM

@Felipe_Ribeir0 

 

thank you, this seems to be working! although how come only some of the rows are collapsing? 

I see have some delegates with a null in between like so :

 

Delegate1Delegate2Delegate3
Louis.Stevens@hotmail.comLouis.Stevens@hotmail.com

 

i am seeing this with delegates 1 , 2 and 3 fields.

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

@wonka1234 

 

Be sure that you have Delegate columns only from the left on this join:

 

Felipe_Ribeir0_0-1673310473614.png

 

Reply
0 Likes
wonka1234
10 - Fireball
‎01-09-2023 04:35 PM

@Felipe_Ribeir0i  did that? could it be anything else? I have 11 delegate columns in actuality. and my last column is always filled (before your workflow addition).  sigh.

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

@wonka1234 Its possible for you to isolate some rows with all columns showing this problem and share here?

Reply
0 Likes
wonka1234
10 - Fireball
‎01-09-2023 04:47 PM

@Felipe_Ribeir0 

 

Before your workflow:

 

WebWeb2Assigned ToStartEndStart2End2StatusSegmentDelegate1Delegate2Delegate3Delegate4Delegate5Delegate6Delegate7Delegate8Delegate9Delegate10Delegate11
CO13CO12Ren.Stevens@hotmail.com4/17/20235/12/20236/26/20237/28/2023NOT STARTEDRedLouis.Stevents@hotmail.com         

Louis.Stevents@hotmail.com

 

 

 

 

after

 

 

WebWeb2Assigned ToStartEndStart2End2StatusSegmentDelegate1Delegate2Delegate3Delegate4Delegate5Delegate6Delegate7Delegate8Delegate9Delegate10
CO13CO12Ren.Stevens@hotmail.com4/17/20235/12/20236/26/20237/28/2023NOT STARTEDRedLouis.Stevents@hotmail.com Louis.Stevents@hotmail.com       
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All