Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Auto check blank cells in the list and add values in order

k3pineapple
8 - Asteroid

Hi  All,

 

I would like to build something like a Auto check Blank in order of a list and then add the values in there, need your assistance

 

Sample Input Data

FirmUser#ProductSales1Sales2Sales3Sales4Sales5Sales6Sales7Sales8
A100000AppleAmyBobCindyDaveEasonFrankGeoHen
A100000BananaAmyBobCindyDaveEasonFrankGeoHen
A100000CheeryAmyBobCindyDaveEasonFrank  
A100001DateAmyBobCindyDaveEasonFrankGeo 
A100001EggAmyBobCindyDaveEason Geo 
A100001FruitAmyBobCindyDaveEasonFrankGeo 
A100002AppleAmyBobCindyDave FrankGeo 
A100002BananaAmyBobCindyDaveEasonFrankGeo 
A100002CheeryAmyBobCindyDaveEasonFrankGeo 
A100003AppleAmyBobCindyDaveEasonFrankGeo 
A100003BananaAmyBobCindyDaveEasonFrankGeo 
B200000AppleAmyBobCindyDaveEasonFrankGeo 
B200000BananaAmyBobCindyDaveEasonFrankGeo 
B200000CheeryAmyBobCindyDave    
B200000DateAmyBobCindy     
B200000EggAmyBob Dave    
B200000FruitAmy CindyDave    

 

 

Sample Output

FirmUser#ProductSales1Sales2Sales3Sales4Sales5Sales6Sales7Sales8
A100000AppleAmyBobCindyDaveEasonFrankGeoHen
A100000BananaAmyBobCindyDaveEasonFrankGeoHen
A100000CheeryAmyBobCindyDaveEasonFrankXZ
A100001DateAmyBobCindyDaveEasonFrankGeoX
A100001EggAmyBobCindyDaveEasonXGeoZ
A100001FruitAmyBobCindyDaveEasonFrankGeoX
A100002AppleAmyBobCindyDaveXFrankGeoZ
A100002BananaAmyBobCindyDaveEasonFrankGeoX
A100002CheeryAmyBobCindyDaveEasonFrankGeoX
A100003AppleAmyBobCindyDaveEasonFrankGeoX
A100003BananaAmyBobCindyDaveEasonFrankGeoX
B200000AppleAmyBobCindyDaveEasonFrankGeoX
B200000BananaAmyBobCindyDaveEasonFrankGeoX
B200000CheeryAmyBobCindyDaveXZ  
B200000DateAmyBobCindyXZ   
B200000EggAmyBobXDaveZ   
B200000FruitAmyXCindyDaveZ   

 

Thank you very much

2 REPLIES 2
gyang3
Alteryx
Alteryx

@k3pineapple here's one way to go about solving your problem. The way I went about it initially is to attach record IDs to each row so I can keep track of the order; using Transpose tool to pivot the table so I have all of the blank cells in a single column; using a Multi-Row Formula tool to specify conditions for populating values in those blank cells. 

gyang3_0-1666816118255.png

 

Hopefully this helped solved your problem!

If so, please mark as solution so others may use it as well!

k3pineapple
8 - Asteroid

Thank you very much for the help

Labels