Power Query
published
Search
K
Comment on page

Table.RemoveRowsWithErrors

Table.RemoveRowsWithErrors

Returns a table with the rows removed from the input table that contain an error in at least one of the cells. If a columns list is specified, then only the cells in the specified columns are inspected for errors.
function (table as table, optional columns as nullable list) as table

Description

Returns a table with the rows removed from the input table that contain an error in at least one of the cells. If a columns list is specified, then only the cells in the specified columns are inspected for errors.

Category

Table.Row operations

Examples

Remove error value from first row.
Table.RemoveRowsWithErrors(Table.FromRecords({[Column1=...],[Column1=2], [Column1=3]}))
Table.FromRecords({[Column1=2], [Column1=3]})