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
$ ctrl+enter to run

Transform Reference

from

Start your query here. Point it at a table or use inline data.

$ from
$ ctrl+enter to run

filter

Keep only the rows you want.

$ filter
$ ctrl+enter to run

extend

Add computed columns to your results.

$ extend
$ ctrl+enter to run

sort

Order your results by any column.

$ sort
$ ctrl+enter to run

take

Grab only the first N rows.

$ take
$ ctrl+enter to run

distinct

Remove duplicate rows.

$ distinct
$ ctrl+enter to run

aggregate

Summarize your data with counts, sums, averages, and more.

$ aggregate
$ ctrl+enter to run
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.