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

Table.RemoveRowsWithErrors

Owen Duncan|Last Updated: 4/19/2018

About

Returns a table with all rows removed from the table that contain an error in at least one of the cells in a row.

Table.RemoveRowsWithErrors(table as table,  optional columns as nullable list) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
optional columnsOnly cells in the column list are inspected for errors.

Remarks

  • Only errors detected by directly accessing the cell are considered. Errors nested more deeply, such as a structured value in a cell, are ignored.

Example

Table.RemoveRowsWithErrors(  

    Table.FromRecords({[Column1=...],[Column1=2], [Column1=3]}))  

equals  
Column1
2
3
© 2018 Microsoft