Transform Functions

📄️ AddColumn

AddColumn(table Table, vector Column1, Column2, ...)

📄️ AddLookupColumn

Extend a table by looking up specified columns in a key-value list.

📄️ AddRow

AddRow(table Table, vector Column1, string value)

📄️ Filter

Filter (table Table, vector Conditions)

📄️ InMemoryTable

Stores a table as in-memory representation.

📄️ InmemoryLookup

Looks up the specified value in the key column and returns the corresponding value.

📄️ LoadFile

Returns the byte stream of a file.

📄️ LookUp

Lookup(table Table, scalar|vector lookupColumnKey, scalar lookupColumnValue, scalar|vector defaultValue, vector lookupValue1, vector lookupValue2,..)

📄️ Next

Shifts the specified vector up by one.

📄️ GroupBy

GroupBy(table Table, vector SelectExpression, vector GroupExpression)

📄️ Previous

Shifts the specified vector down by one.

📄️ Rank

Assigns rank for a group of rows based on the given group by and order by conditions.

📄️ Select

Create a new table using the specific columns.

📄️ SelectRange

Create a new table using rows that fall between the Start Row and the End Row in the specified source tables.

📄️ Transform Functions

📄️ SelectRow

SelectRow (table Table, vector RowIndex)

📄️ SelectValue

SelectValue (vector Column, scalar Index)

📄️ Sort

Performs a nested sort operation on the provided table.

📄️ Transpose

Transpose function transposes a table.

📄️ Unique

Returns a list of unique values for the given columns.

📄️ AppendTable

AppendTable (table Table1, Table2,...)

📄️ AppendTableOnNames

AppendTableOnNames (table Table1, Table2,...)

📄️ MissingValues

MissingValues(vector Column)

📄️ RunSQL

RunSQL (scalar query, table tables)

📄️ SplitTextInColumns

SplitTextInColumns (vector KeyColumn, vector StringValue, scalar Number of characters, scalar Number of columns, scalar Maintain word boundary, scalar Stuff…