Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.ReplaceErrorValues

Owen Duncan|Last Updated: 4/19/2018

About

Replaces the error values in the specified columns with the corresponding specified value.

Table.ReplaceErrorValues(table as table, errorReplacement as list) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
errorReplacementThe list of columns and the value to replace the errors with. The form of the list is {{column1, value1},…}

Remarks

  • There may be only one replacement value per column, specifying the column more than one will result in an error

Example

Table.ReplaceErrorValues(  

    Table.FromRows({{1,"hello"},{3,...}}, {"Column1","Column2"}),  

    {"Column2", "world"})  
Column1Column2
1hello
2world
© 2018 Microsoft