Replacing Null Fields with Imputation

ROUD89

Hi,

I have an error using imputation in a dataset. When I use imputation I choose to replace [NULL] with the median. However, the result is that EVERY value in this variable becomes [NULL] instead of the desired effect. Any help here?

These are my variables, the variable that I wan to impute is Age-years, with field type 'Double' 

As you can see in my photos, the Age-years variable has become solely [NULL] values.my variablesmy imputationthe result which is not desired

SeanAdams

Hey @ROUD89

The imputation tool does do funny things with field names - I did the same as in your example, and the field with the original name comes back all null, but a new field with good values but a slightly different name (instead of age-years, it comes back as age_years) comes back with correct values.

I suspect that the reason that the imputation control does this is because it depends on the cross-tab control under the covers (which has this odd behavior with field names too).

Have a look at the attached workflow - hope this helps.    If not - feel free to post an alteryx workflow with a test data set and we can work together as a community to crack it with you.

Cheers

Sean

New Alteryx Workflow.yxmd