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.
Solved! Go to Solution.
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
Try to make the modifications that I suggested in the previous post yourself. If you run into any issues, post what you've managed to accomplish and I'll look at it.
Dan
Will do thank you for your help. I'm doing that now as we speak!