20 docs tagged with "Transform"

AppendTable (table Table1, Table2,...)

AppendTableOnNames (table Table1, Table2,...)

Finds the records from the left table that match on the specified key columns but differ on any other columns, to a corresponding record in the right table.

Finds the records from the left table that do not have a corresponding match in the right table on the specified key columns.

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

Stores a table as in-memory representation.

Returns the byte stream of a file.

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

MissingValues(vector Column)

Shifts the specified vector up by one.

Shifts the specified vector down by one.

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

RunSQL (scalar query, table tables)

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

SelectRow (table Table, vector RowIndex)

SelectValue (vector Column, scalar Index)

Performs a nested sort operation on the provided table.

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

Transpose function transposes a table.

Returns a list of unique values for the given columns.