errorReplacer M function | Substitute error values in all or listed scanColumns with a specified value or null if no replacement is provided.

errorReplacer.pq

(t as table, optional replacementValue as any, optional scanCols as list) as table =>
let
    colNames = Table.ColumnNames(t),
    selCols = List.Intersect({colNames, scanCols ?? {}}),
    replErrors = Table.ReplaceErrorValues(t, 
        List.Transform(
            if List.IsEmpty(selCols) then colNames else selCols, 
            each {_, replacementValue}
        )
    )
in
    replErrors