This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
The imputation tool is reducing the number of columns in my data set. I am feeding in 100+ columns but only looking to impute 5 of them. The output of the tool has < 100 columns which seem to be dropped at random. Unless I am using the tool incorrectly, can you please advise on this?
I was able to take a look here. Under the hood, the tool has a regex statement to deselect the imputed value indicator field and the secondary imputed values field when the below settings are checked.
The regex inside the dynamic select tool is looking for fields that contain _ followed by a string containing either mp or nd (the fields created by the tool have suffix of either _Indicator or _ImputedValue)
It just so happens that your field names match the regex written with _INDUST.
To Navigate around, rename the fields to a name that does not contain 'IN' after an _ such as INDUST_ERNINGS_AGE or select output 'imputed value indicator.'
I'm trying to complete a tutorial and am using the Imputation tool to remove null values and replace with a median value. The problem I'm experiencing is that only the very first column of the data-set is appearing under the 'Fields to impute'. Why don't I see all of the columns?