DRAFTThis page is not published. Only visible in development mode.
Transforms
Transforms are how you shape your data in RQL. Chain them together to filter, compute, and aggregate.
Pipeline Processing
Every query is a pipeline. Your data flows from one transform to the next. Each step takes the output of the previous one.
$ Pipeline Processing
Transform Reference
from
Start your query here. Point it at a table or use inline data.
$ from
filter
Keep only the rows you want.
$ filter
extend
Add computed columns to your results.
$ extend
sort
Order your results by any column.
$ sort
take
Grab only the first N rows.
$ take
distinct
Remove duplicate rows.
$ distinct
aggregate
Summarize your data with counts, sums, averages, and more.
$ aggregate
More Transforms
More transforms are on the way:
derive, deferred, append, union, map, view, with, create, and insert. Documentation coming soon.Next Steps
Ready for more? Learn about operators and functions in Expressions.
