Issue with data cleansing tool

Hi Team

I’m facing trouble trying to work with the data cleansing tool, attached is a sample workflow for reference where the error for updating blank cells with 0 is not letting the tool to function properly (screenshots below). Could you kindly assist?

Pls let me know if you need further information from my side.

sample Workflow - data cleansing not working.yxmd

Macros

Accepted answers

All comments

Raj

@asinganguly
it is always better to use formula tool instead
Mark done if solved.

sample Workflow - data cleansing not working.yxmd

asinganguly

But that's not the point, i know the formula tool is a work around. But i need to work with the cleansing tool, it's working for new other folks but not for me.

I've a model built that utilizes the cleansing tool at various places, so need it to work. Thus, this community post searching for the fix

Raj

@asinganguly the workflow attached by you work perfectly fine for me on the run
you need to readd the data cleansing tool

asinganguly

Right, it's working for others but I'm getting the errors (noted in the screenshots), so not sure what's the issue. Tried adding, re-adding, nothing seems to work.

If I uncheck the "updating blank cells with 0" option, it works again. So unclear what or why is the issue

But I need it to work with the above checked

alexnajm

Do you have "Disable Auto Configure" turned on in your settings? That's the only thing I can think of off the top of my head.

Otherwise submitting a case through Mission Control is likely your best solution as it'll be something very specific to your computer since the workflow works for the majority of people (including myself)

diegosantos

@asinganguly

Did you have check / compare your version of Alteryx Designer with your colleagues? Maybe your version is different.

apathetichell

turn off amp. rerun. -> and keep in mind that datacleanse is a local macro - so it's possible that yours was corrupted.

asinganguly

Thank you for your responses,

1. Auto configure isn't disabled

2. I'm using the latest version, colleagues are using the same

4. AMP is turned off

Corruption can be an issue, in that case would the solution be to uninstall & install again? Or is there a better fix?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703