Data Preparation
Components to prepare your data for downstream analysis, this can include altering a table structure, re-ordering data, subsampling data, etc.
Description
This component casts the content of a column to a given type
Inputs
Source table [Table]
Column [Column]
New type [Selection]
Outputs
Result table [Table]
Description
This component creates a new table with an additional column computed using an expression.
Inputs
Source table [Table]
Name for new column [String]
Expression [String]
Outputs
Result table [Table]
External links
Description
This component generates a new table with the same content as the input one, except one of its columns.
The component will fail if the column to remove is the only one in the input table.
Inputs
Source table [Table]
Column [Column]
Outputs
Result table [Table]
External links
Description
This component creates a new table with an additional UUID column named 'uuid'.
Inputs
Source table [Table]
Outputs
Result table [Table]
Description
This component converts a column from geography to geometry data type.
Inputs
Source table [Table]
geography column [Column]
Outputs
Result table [Table]
Description
This component converts a column from geometry to geography data type.
Inputs
Source table [Table]
Geometry column [Column]
Outputs
Result table [Table]
Description
This component filters an input table using the presence or absence of null values in a given column.
Inputs
Source table [Table]
Column [Column]
Outputs
Not null values table [Table]
Null values table [Table]
Description
This component creates a new table with only the N first rows of the input table.
Inputs
Source table [Table]
Number of rows [Number]
Outputs
Result table [Table]
External links
Description
This component normalizes the values of a given column.
It adds a new column named '[column_name]_norm'.
Normalization can be computed as 0-1 values or as z-scores
Inputs
Source table [Table]
Column to normalize [Column]
Use z-scores [Boolean]
Outputs
Result table [Table]
Description
This component generates a new table containing the rows of an input one sorted according to the values in one of its columns, and an optional second column.
Columns to use cannot be of type geometry.
Inputs
Table to order [Table]
Column to order by [Column]
Use descending order [Boolean]
Optional secondary column to order by [Column]
Use descending order in secondary column [Boolean]
Outputs
Result table [Table]
External links
Description
This component takes an input table and generates a new one in which duplicates rows from the input table have been removed.
Inputs
Source table [Table]
Outputs
Result table [Table]
Description
This component generates a new table with the same content as the input one, renaming one of its columns.
Inputs
Source table [Table]
Column to rename [Column]
New column name [String]
Outputs
Result table [Table]
External links
Description
This component generates a new table with a random sample of N rows from an input table.
Inputs
Source table [Table]
Number of rows to sample [Number]
Outputs
Result table [Table]
Description
This component runs an arbitrary SELECT statement.
It generates a new table from a SELECT statement applied on the input table.
Inputs
Source table [Table]
SELECT statement [String]
Outputs
Result table [Table]
External links
Description
This component generates a new table with the unique values that appear in a given column of an input table.
Inputs
Source table [Table]
Column [Column]
Outputs
Result table [Table]
External links
Description
This component filters an input table according to a filter expression based on a single column.
It generates a new table with only the rows of the input table that meet the filter criteria and another one with those that do not meet it.
Inputs
Source table [Table]
Column [Column]
Operator [Selection]
Value [String]
Outputs
Table with rows that pass the filter [Table]
Table with rows that do not pass the filter [Table]
Description
This component filters an input table using a spatial predicate and a filter table.
It generates a new table with only the rows of the input table that meet the filter criteria and another one with those that do not meet it.
Inputs
Source table [Table]
Filter table [Table]
Geo column in source table [Column]
Geo column in filter table [Column]
Spatial predicate [Selection]
Outputs
Table with rows that pass the filter [Table]
Table with rows that do not pass the filter [Table]
Description
This component sets the SRID of a geo column
Inputs
Source table [Table]
Geo column [Column]
SRID [String]
Outputs
Result table [Table]
Description
This component filters an input table according to a filter expression.
It generates a new table with only the rows of the input table that meet the filter criteria and another one with those that do not meet it.
Inputs
Source table [Table]
Filter expression [String]
Outputs
Table with rows that pass the filter [Table]
Table with rows that do not pass the filter [Table]
External links
Last modified 5d ago