How to replace missing values with their median

harsha6055

I know by using aggregate we can get median but not getting to replace missing values by median value.

Caperez

Hi @harsha6055,

in this case you can use the Aggregate operator to find the median value and use it as a macro to replace the value using the Replace Missing Values operator. 

Please find attached a simple sample using a modified golf dataset. 

Best, 

Cesar

golf.xlsx

missing macro.rmp