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
Cutom step
Delete column(s)
Duplicate
Duration
Evolution
Extract date property
Extract substring
Fill null
Filter
Formula
Get unique groups/values
Hierarchical rollup
ifthenelse
Join
Keep column(s)
Moving Average
Percentage
Pivot
Rank
Rename
Replace
Sort
Split column
Column's Statistics
To lowercase
To uppercase
Top N rows
Unpivot
Waterfall
Convert text column to date
You can use this step to cast a text column to date.
This step is supported by the following backends:
- Mongo 4.2
- Mongo 4.0
- Mongo 3.6
Where to find this step?
- Widget
Date
- Search bar
- Column header data type icon
Options reference
</br>
</br>
</br>
-
Column to convert:
: the text column to be converted to date -
format:
: either ‘Try to guess’ (the backend tries to infer the date format of your column), ‘Custom’ (to allow you to enter a custom format in thecustom format
parameter below), or a preset (e.g. “%d-%m-%Y”). Please see the Mongo documentation for Mongo custom supported formats.
Example
This configuration results in:
- Previous
- Next