Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

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

Imputation Tool Bug - Always converts to double

dyamichael
7 - Meteor

Whenever I impute a subset of numeric fields, every numeric field is converted to a double regardless of whether I chose to impute it or not.

 

This is a huge issue when I work with fixed decimal fields. All results get rounded to the nearest integer, regardless of whether I chose to impute the field or not.

 

Attached is an example workflow.

 

Cheers,

Michael Dyatchenko

9 REPLIES 9
DanM
Alteryx Community Team
Alteryx Community Team

@dyamichael thanks for the find. We have escalated this up to get this resolved. You do have other options if you are attempting to just replace Nulls with zeroes. You can use the Multi-field formula tool to replace the nulls with 0 or use the Data Cleanse.

 

You also have the option of running the data through the Imputation tool as a Double and then changing it to a Fixed Decimal after the Imputation tool.

 

Thanks again!

OldDogNewTricks
10 - Fireball

Any update on this?  Plans to fix?  I just discovered this error as well.  It rounds all numeric values to integers, less than ideal.  Therefore converting after the fact is useless as the decimals have already been cut off.

DanM
Alteryx Community Team
Alteryx Community Team

@OldDogNewTricks,

 

We do have this as a planned fix. I am working on giving it a little push.

 

DanM

AlexanderAdams
5 - Atom

It looks like this issue is still happening.

Do we have an update on when this will be resolved?

DanM
Alteryx Community Team
Alteryx Community Team

@AlexanderAdams This is still planned. We don't have an eta on this change yet. Thanks for your patience.

 

DanM

Robin_MasonBreese
6 - Meteoroid

I'm experiencing this now I take it it was never fixed?

phoebe_kelley
9 - Comet

I am also having this issue. I have switched to a different tool, but it would be nice to use this tool and not have it round to an integer!

jpoz
Alteryx
Alteryx

@JeffF 

phoebe_kelley
9 - Comet

Ah, I see it was fixed in 2020.2 (this thread), which I haven't updated to yet (dang server!) I will update my imputation tools to version 3 in existing workflows once I update. For now I'll just use the multi-field formula tool. Thanks!

 

Labels