General Principles Add text column Aggregate Append Argmax Argmin Concatenate columns Convert Extract date property Delete column(s) Duplicate Fill null Filter Formula Join Keep column(s) Percentage Pivot Rename Replace Sort Split column Extract substring To lowercase To uppercase Top N rows Unpivot Get unique groups/values
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.
- We only support mongo 3.6 at the moment
- We do not support transformation of text and date at the moment
- We do not support combination of several queries (such as append or join)
- Filter step: we only support “and” conditions (not “or”)
- Formula step: we do not support column names that include whitespaces