Alteryx Imputation Tool Isn't Working!

Question

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

AncientPandaman · Accepted Answer

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

how silly am I 🤣

JaniceTsengLee · Accepted Answer

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

alexnajm · Accepted Answer

It’ll be in your MyAlteryx page! Under Case Management: https://my.alteryx.com/

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

alexnajm · Accepted Answer

After a bit of hounding, Alteryx finally updated the documentation as well! Tool Use with AMP