Data cleaning help

so I have a situation where I have data that needs desperate cleaning. In the example below under Provider Type and Provider Phone number I need to replace the number with the majority number listed. Under ProviderLicense I need to replace the nulls with the with the License number.

Common Use Cases

Accepted answers

Here ya go!

Dan

data cleaning sample.yxmd

In the 2 summarize tools and also the 2 Sample tools, additionally group by the HCP Provider name. In the Sort tools add an additional sort by HCP Provider name and make sure its the first in the list. Then you can change the 2 append fields tools to normal Join tools join both on HCP provider name

Dan

All comments

Can you provide some sample data?

What do you want to do with the Provider Type.

In your description you mention "majority number". Which field does this come from.

Dan

Here you go.

data cleaning sample.yxmd

Hey @COrr ,

A little unclear at this moment as far as what's being replaced - are you looking to fill down the empty License field?

If so, a multi-row tool will do that for you, set to update ProviderLicense, with an expression of:

If IsNull([ProviderLicense]) then [Row-1: ProviderLicense]

Else [ProviderLicense]

Endif

If there's some more to it, feel free to post an example of what you'd like your end result to be.

Example workflow attached

data cleaning sample_2.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703