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, optionalcolumns
as nullable list) as table
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.
Table.Row operations
Remove error value from first row.
Table.RemoveRowsWithErrors(Table.FromRecords({[Column1=...],[Column1=2], [Column1=3]}))
Table.FromRecords({[Column1=2], [Column1=3]})
Last modified 4yr ago