Alteryx Imputation Tool Isn't Working!

[JaniceTsengLee]

Hi everyone,

I’m just beginning to learn Alteryx Designer and am trying to use the Imputation Tool to replace two null cells in the last_spent field with the median value 55.8.

After configuring the tool to replace nulls with the median, the workflow ran successfully — but instead of returning 55.8 for the two null records, Designer returned 7.57 for record 1 and 37.59 for record 10.

 

To troubleshoot, I tried switching the “Replace With Value” configuration to other options (e.g., Average and Mode), but Designer continued to output 7.57 and 37.59 for those same records. It seems my Imputation Tool isn’t imputing the values correctly.

Has anyone encountered this issue before? What could be causing the tool to behave this way, and how can I fix it?

 

Thank you so much for your help!

— Janice

[alexnajm]

Interesting... I am getting the same behavior. It would be worth submitting a case to Alteryx for this!

In the meantime, here's a workaround 😊

[JaniceTsengLee]

Thanks, Alexnajm. I created the exact same workflow to workaround the issue. But I am dying to fix my imputation tool. How do I raise a case to Alteryx? Appreciate your help! 

[PangHC · Accepted solution]

EDIT: the sorting issue is due to the AMP engine?

how silly am I 🤣

[JaniceTsengLee]

Problem solved!!!!!!!! Just enable the AMP Engine in Run Workflow Configuration. Thank you @PangHC 😀

[alexnajm]

It’ll be in your MyAlteryx page! Under Case Management

At least there’s a workaround if people need it for some

reason 😊