Power Query
Search…
published
Powered By GitBook
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.
1
Table.RemoveRowsWithErrors(Table.FromRecords({[Column1=...],[Column1=2], [Column1=3]}))
Copied!
Table.FromRecords({[Column1=2], [Column1=3]})
Last modified 3yr ago