Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

What would be the best way to fill in missing data?

Highlighted
7 - Meteor

Please see the attached. I can't use the multirow tool because it ends up being a catch all type formula. If using the formula based on what's in the row below or row above it may end up filling in the wrong information for some people based on where the missing data is. 

 

Is there another way to fill in data appropriately?

 

End result should be: 

Emp IDNameRes StateVacationsCompositeIncTax
123BobALHI | PA |CAWI879652
123BobALHI | PA |CANY456234
123BobALHI | PA |CACA124837
123BobALHI | PA |CAIN138418
789SarahGAHI | PA |CAWI879652
789SarahGAHI | PA |CANY456234
789SarahGAHI | PA |CACA124837
789SarahGAHI | PA |CAIN138418
963JackWIHI | PA |CAWI879652
963JackWIHI | PA |CANY456234
963JackWIHI | PA |CACA124837
963JackWIHI | PA |CAIN138418
487NickTXHI | PA |CAWI879652
487NickTXHI | PA |CANY456234
487NickTXHI | PA |CACA124837
487NickTXHI | PA |CAIN138418

 

Highlighted
Alteryx Partner

@znooredeen002 - consider filtering out the records with null values, creating a lookup table using a summarize tool and joining the updated records back to complete your data set to fill in the table.

1.PNG

Highlighted
Alteryx Partner

Hi @znooredeen002 ,

 

In this particular case I would first simply identify the unique Employee name & Resident State where the key is not zero/null.

 

Once you've done that, you can simply join back to the original data set on the name & resident state and collect the values.

 

Regards,

Tom

Labels