Nota
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tidħol jew tibdel id-direttorji.
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tibdel id-direttorji.
Syntax
Table.RemoveRowsWithErrors(table as table, optional columns as nullable list) as table
About
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.
Example
Remove error value from first row.
Usage
Table.RemoveRowsWithErrors(
Table.FromRecords({
[Column1 = ...],
[Column1 = 2],
[Column1 = 3]
})
)
Output
Table.FromRecords({
[Column1 = 2],
[Column1 = 3]
})