Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Above the Data Grid, you can review summary information about the data in your currently selected sample. 

Image Modified

 

D caption
typefigure
Dataset Summary

Tip

Tip: Before you begin transforming your data, you might want to verify the columns and count of data types against the data before it was imported. If there are discrepancies, you might want to choose a different sample or otherwise investigate the differences. Unless your sample includes the entire dataset, row counts should differ.

...

Info

NOTE: In the Photon running environment, results can differ between executions of the same recipe due to Photon's parallel execution and data limiting within the Transformer page. In particular, joins with multiple matches per key can sometimes cause a difference in the number of reported rows when the job is re-executed.

  • To review and analyze across multiple columns, click Columns. See Column Browser Panel.
  • To return to the data grid, click Grid.
  • To review the samples for the loaded dataset, click the dataset link. See Sampling Menu.
  • Click the data types link to review the data type for each column. See Supported Data Types.

  • Grid menu: Select the type of display for

    Filter: Enter text to begin filtering the rows for display in the data grid.

     

    For more information on column details, see  Column Details Panel .

Tip

Tip: When you are previewing a recipe step, click the Transformed link to display in the data grid only the rows that have been modified by the currently configured recipe.

 

...

Data Grid Options

Use the right-hand menu to toggle display of various features in the Transformer page:

  • Preview: Toggle display of previews of changes. For large datasets containing dozens of columns, disabling previews can improve performance.
  • Show Whitespace:  When enabled, non-visible characters such as spaces, new lines, and tabs appear in the data as pink icons.

    Info

    NOTE: If you are using imported datasets with fixed-width columns, you should disable the Show Whitespace option. These columns can conflict with the platform's ability to compute a cell's whitespace, which can impact performance and can cause the browser to crash.

  • Card Suggestions: Toggle display of the transform cards, which can be used for quickly applying transform steps on individual columns. Cards are only displayed if a suggestion for your current selection is available. 
  • Show
    D s lang
     Script:
    Toggle display of recipe steps in either natural, readable language or in native
    D s lang
    fulltrue

Column Information

At the top of the column, you can review:

...

Tip

Tip: If you hover over a bar in the histogram, you can review specific values, the count of that value, and the percentage that value represents of the total count of values in the column.

Column actions

  • To change the data type of a column, click the icon next to the column name. See Supported Data Types.

  • Column commands:  Click the drop-down next to the column title to review the following options. Except for Column Details and Hide, all commands add recipe steps.  

    • Sort ascending/descending: Sort the values in the column by ascending or descending value.
      • When a column is sorted in ascending order, the bottom values are mismatched and null values, in that order. These values appear at the top of the column when sorted in descending order.
    • Lookup: Perform a lookup of the columns values against a set of values in another column of another dataset. See Lookup Wizard.
    • Column Details: Explore the interactive profile of the column details. See Column Details Panel.
    • Rename: Change the name of the column.

    • Hide: Hide display of this column. To redisplay this column, you must select it in the Column Browser. See Column Browser Panel.

      Info

      NOTE: Hidden columns still appear in any generated output.

    • Drop: Drop this column from the output.

For more information, see Column Menus.

Selecting values

You can click and drag to select values in a column:

...