Page tree


Support | BlogContact Us | 844.332.2821

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

In the Transformer page, you identify the data that you need to transform and build your transformation recipes on samples that the

D s webapp
 has taken from your currently selected dataset. When you make changes to your transformation recipe, those changes are immediately applied to your sample, so that you can preview the results of your recipe before you run it against the entire dataset. In this manner, you can quickly build and iterate on the transformations applied to your data.

  • In the Datasets page, click the name of the dataset. See Datasets Page.
  • By default, the 
    D s webapp
     selects the first N of row data as the working sample. The number of rows depends on the number of columns, data density, and other factors. Depending on the size, this sample may be the full dataset.

D caption
Transformer Page

Page Uses

Identify and Select Data

In the available panels of the Transformer page, you can select one or more elements of data, which prompts suggestions for steps that you can apply to transform them. Each of these views provides a different perspective on visually profiling your data, and the results of any subsequent steps that you select or configure are previewed by default in the data grid:


Tip: Selecting values in any of the three panels generates a new set of suggestions.


PanelDescriptionRecommended Uses
Data Grid By default, the Transformer page displays previews in a columnar grid, which is the default view. Click Grid.Use for examining values in a column with appropriate surrounding context. How do missing values in one column compare to values in another column?
Column Details

For additional statistical information on individual columns, select Column Details from the drop-down next to the column title.

Explore values in an individual column, when their context in other rows is not necessary. Useful for managing outliers, reviewing mean, min, and max values.
Column Browser

Use the Column Browser to select the columns to display and review data across columns. Click Columns.


Tip: Click the number of columns in the Dataset Summary bar to open the Column Browser. See Dataset Summary below.

Navigate between columns and toggle their display in the Data Grid. Good for high-level perspective. Use histograms for selection of ranges of values.

Get Statistics

You can use the following methods for acquiring statistics on your dataset or individual columns in your dataset:

  • Sample bar: At the top of the data grid, you can see statistics on the sample currently displayed in the grid. For smaller datasets, this sample is the entire dataset. 

  • Column statistics: You can review basic statistics on individual columns through the column details in Column Browser, available on the left side of the screen. See Column Browser Panel.
  • Profile your data: When you run a job on your dataset, you can optionally generate a profile of the resulting output. See Results Page.

  • Computed statistical functions: As needed, you can generate aggregated statistics as part of your recipe. See Aggregate Functions.

Build Recipes

Use the following methods to add or modify recipe steps in the Transformer page:

  • Transform Cards: By default, when you select data in the Transformer page, a set of suggested transformations is displayed in cards at the bottom of the page. Select the appropriate one to preview the results in the data grid. See Transform Cards Panel.
  • Transform Builder: Build complete transform steps by selecting from context-aware menus. The available menu options change based on the selections that you make. See Transform Builder.
  • Transform Editor: If you are comfortable working with scripting, you can build your transformations as a series of steps scripted in
    D s lang
    . The Transform Editor provides type-ahead support, so you can rapidly assemble your next recipe step. 
  • Recipe Panel: After recipe steps have been created, you can review and edit them through the Recipe panel. 
    • By default, the Recipe panel is hidden on the right side of the menu. Click the Recipe icon to toggle its display. See Recipe Panel
  • Transform Preview: Before a transform step has been added to the recipe, a preview of the transform is displayed in the data grid. See Transform Preview.

Launch Jobs

Generate Results: To generate the results from the transform recipe currently in the Transformer page, click Generate Results. See Generate Results Dialog

Transformer Menu Bar

The Transformer page contains menus that are different from the standard 

D s item
itemmenu bar


The Transformer page contains menus that are different from the standard 

D s item
itemmenu bar

  • Dataset menu: Click the drop-down next to the dataset name to select one of the other datasets in the flow to transform. See Dataset Browser
  • Dependencies Graph: You can explore the datasets that are integrated into the current one and the datasets that depend on it.

    D caption
    Dependencies Graph


    • The first value indicates the number of datasets on which the current dataset depends.

    • The second value indicates the number of datasets that depend on the current dataset.


      Tip: If the second value is greater than 1, then other datasets depend on the current one. Changes in your current dataset can cause breakages and other dependency issues in downstream datasets. For more information, see Fix Dependency Issues.

    • These datasets can be explored in the Dependencies Browser. To open, click the graph. See Dependencies Browser.
  • Generate Results: Runs the currently specified recipe on the dataset. See Generate Results Dialog.
  • User menu: Review your user profile. See User Profile Page.
  • Help menu: Begin a chat session with
    orquery documentation resources for answers to your questions.