General Principles
Add Missing Dates
Add text column
Add Total Rows
Aggregate
Append
Compare Text Columns
Argmax
Argmin
Concatenate columns
Convert
Convert date to text
Convert text to date
Cumulated sum
Custom step
Delete column(s)
Geographically dissolve data
Duplicate
Duration
Evolution
Extract date information
Extract substring
Fill null
Filter
Formula
Geographical hierarchy
Get unique groups/values
Hierarchical rollup
ifthenelse
Join
Keep column(s)
Moving Average
Percentage
Pivot
Rank
Rename
Replace
Geographical simplification
Sort
Split column
Column's Statistics
To lowercase
To uppercase
Top N rows
Unpivot
Waterfall
Split column
You can use this step to split a text column into several columns, based on a delimiter.
This step is supported by the following backends:
- Mongo 5.0
- Mongo 4.2
- Mongo 4.0
- Mongo 3.6
- Pandas
Where to find this step?
- Widget
Text
- Search bar
Options reference
-
Split column
: the column to be splitted -
Delimiter
: a character or a string of characters that will be identified as delimiter to split the column -
Number of columns to keep
: the number of columns to keep after spklitting the original column
The original column remains intact while the split results are written in
specific columns automatically named after the original column name (in the
form original_column_name_1
, original_column_name_2
etc.).
Example
This configuration results in:
- Previous
- Next