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.