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
Known limitations
This doc section is here to identify a non exhaustive list of limitations that we have in mind, and that we want to tackle in further developments.
Supported mongo versions
We only support mongo 4.4.x & 5.x at the moment.
Result ordering with PyPika SQL translator
Because some SQL backends do no keep the original row ordering when grouping, JOINing or doing UNIONs, several steps do an ORDER BY in order to ensure consistent result, meaning the inital row order is not preserved.
- Previous
- Next