Query transformations

After the data is retrieved from the data provider, it can be transformed using functions.

There are several ways to add transformations:

• Edit table as you normally would.
• Add steps manually from toolbox.
• Use table context menu

All data transformations done via the UI are recorded as macros, and can be replayed.

You can manually edit steps parameters.

You can add steps manually and switch between steps to view results of each step.

Videos

See also:

• Data connection
• Data query
• Function call
• Aggregate rows
• Recipe Editor