Fill empty cells based on previous rolls, grouped by other field

[mauricio]

Hi!

I'm trying to fill some blank cells with the following logic:

If the cell in [value] is blank, then search the rows with the same [key] find the mode of the [value] with the same [key], them, fill the blank with the mode.

I tried to use the multi row formula, with no success

Any help will be very much appreciated

regards.

[jamielaird · Accepted solution]

Hi @mauricio ,

Here's one approach that works:

Part of your logic means there were a few extra steps required here above what I expected - particularly how we handle null values.

Hopefully it all makes sense but let me know if you have any questions.

[mbarone]

The Imputation Tool on the Preparation palate should do it for you:

[mauricio]

Hi mbarone, thank you for the reply

Unfortunately the imputation tool cant group by values based on another field.

This solution appear to give a output different than the desired

[mauricio]

That will work just fine.

Thank you jamielaird

The solution is much bigger than I expected, but a can't see another way to solve this problem.