Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Imputation tool help needed

SG1982
5 - Atom

Hi All,

 

I have a dataset like below in which I'm trying to replace all the NULL values to 1 using the Imputation tool.

 

SG1982_1-1654245608990.png

 

The output file is generating as follows -

SG1982_2-1654245656067.png

 

My queries -

1. In the first field there were many null records, but in output I can able to see only single "1". Why?

SG1982_0-1654246170705.png

 

2. Why the order sequence is changing after applying the tool?

 

Need assistance with explanation. Kindly assist..

 

2 REPLIES 2
mathieuf
Alteryx
Alteryx

Hi @SG1982,

 

Try to sort your data you should find more than 1 line with 1 value:

 

mathieuf_0-1654249002278.png

 

DataNath
17 - Castor
17 - Castor

I know the recent switch to using AMP as the default engine affected the ordering of outputs for some tools. Not 100% sure whether or not Impute is one of those, but If you need to keep the original order then it may be worth turning that off and giving it a try (in workflow settings).

Labels
Top Solution Authors