  |
GoFiler Legato Script Reference
Legato v 1.4j Application v 5.22b
|
| Table of Contents | < < Previous | Next >> |
Chapter Eight — Data Functions (continued)
TableDeleteDuplicates Function
Overview
The TableDeleteDuplicates function removes duplicate rows of a table based on row content and optionally specified columns.
Syntax/Parameters
Syntax
int = TableDeleteDuplicates ( string table[][], [int column | string column, ...] );
Parameters
table
An array of string data which must resolve to two-dimensions.
column
Zero but not more than three column specifications to used as a basis of comparison. The specification can be an int as a zero-based columns index or a string as a key name. The first specified column is used for the primary comparison. If the first specified column has equal data, the next column is compared. If a key is specified, it must exist. If omitted, all column are compared.
Return Value
Returns an int as as the number of rows removed or a formatted error code. Use the GetLastError function to retrieve error information.
Remarks
The TableDeleteDuplicates function deletes any duplicate rows as measured by the column specification or the entire row. All comparisons are exact matches. when columns are specified, all the other column are ignored during comparison.
Table order is not altered. Not that is row keys are used they key positions are not altered if a row is deleted.
Related Functions
Platform Support
Go13, Go16, GoFiler Complete, GoFiler Corporate, GoFiler, GoFiler Lite, GoXBRL
Legato IDE, Legato Basic
| Table of Contents | < < Previous | Next >> |
© 2012-2024 Novaworks, LLC. All rights reserved worldwide. Unauthorized use, duplication or transmission prohibited by law. Portions of the software are protected by US Patents 10,095,672, 10,706,221 and 11,210,456. GoFiler™ and Legato™ are trademarks of Novaworks, LLC. EDGAR® is a federally registered trademark of the U.S. Securities and Exchange Commission. Novaworks is not affiliated with or approved by the U.S. Securities and Exchange Commission. All other trademarks are property of their respective owners. Use of the features specified in this language are subject to terms, conditions and limitations of the Software License Agreement.