Impute string values

[Tadhgo95]

Hi,

This should be incredibly easy but I'm struggling to find a workaround as the imputation tool only works for numeric values.

I'm just wondering how to replace the null value with "June" in my workflow. See screenshot below.

Any help appreciated.

[NickSm · Accepted solution]

Hi @Tadhgo95 

If it is consistent that every null value should become June in this case, a basic IF statement in a formula should resolve like so:

[Tadhgo95]

Thank you

[benjaminmartin16]

hello,

I am curious what if the string is not constant and you are trying to make an assumption that just replaces the undesireable value with the most frequently appearing value? is there like an if x then mode of y type of thing you can do with strings?