Imputation tool help needed

Question

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.

The output file is generating as follows -

My queries -

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

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

Need assistance with explanation. Kindly assist..

My Data.xlsx

DataNath · Answer

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).

mathieuf · Answer

Hi @SG1982,

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