Navigating table recipes

When you open a table recipe, it provides information on the table recipe and its dependencies as well as an editor for designing the recipe. A table recipe contains two sections:

• Overview: Provides a summary of information about the table recipe, including information on dependencies, run history, and published copies.

• Editor: Provides the single table view of a data sample to add transformations steps to your recipe and run it on the full data.

Overview

The Overview provides general information about a table recipe, its data sources, and its exported files. Four tabs are available in a data flow overview:

• Summary

• Notifications

• Run history

• Published copies

Summary

The Summary provides general information on the data flow creation, updates and status:

• Owner: Owner of the table recipe

• Creator: Creator of the table recipe

• Contributors: Number of contributors to the table recipe. Click to view the names of contributors.

• Space: Space where the table recipe is located

• Created date: Date the table recipe was created

• Modified date: Date the table recipe was last modified

• Last modified by: User who last modified the table recipe

• Last run status: Status of the last table recipe run

• Last run duration: Duration of the last table recipe run

• Last run date: Date of the last table recipe run

• Number of steps: Number of transformation steps included in the table recipe

• Data flow ID: Technical ID of the table recipe

The Summary also has two additional sections, Output and Input:

• Output shows the last file outputted by the table recipe.

• Input shows the source used at the start of your table recipe.

For items listed in Output and Input, click to view additional options. You can view the impact analysis or lineage for each item. You can also open items in a new tab.

Notifications

Notifications lists the different events for which you can receive notifications. You can turn them on or off, and select how you receive the notifications.

Run history

Run history shows a list of the previous table recipe runs, with the status, time and duration of the run. Click View to display a summary and optionally download a detailed log.

Published copies

Published copies shows in which managed spaces copies of the table recipe were published. Each copy shows the following information:

• Name

• Owner

• Last modified

• Space

• Viewed by

Click on the copy to open it in Table recipe. Click to view additional options. You can:

• Add it to a collection.

• Rename it.

• View lineage information.

• View impact analysis.

• View the copy run schedule.

• Open it in a new tab.

• Delete the copy.

Editor

In the Editor, you can work on your table recipe by selecting columns and applying transformation steps.

Actions and panels available in the table recipe editor:

Functions

The Functions panel is the main place to browse the different functions available for your data and to gain some insight with your columns statistics. It contains the following elements:

• The column name section, where the name of the currently selected column is displayed, and from where it possible to start configuring a function to rename the column using .

  

• The Search functions field, where you can start typing the name of a function or a keyword to try to look for the specific function you need.

  

• The list of functions, where you can browse for functions to apply, sorted by categories. Click a function to start configuring it.

  

• The Data distribution section, that you can choose to show or hide, contains statistics on the data contained in the selected column, and takes into account any potential filter. The way data is displayed depends on the data type:

  • For text, the number of occurrences of strings is displayed in the form of a bar chart.

  • For numerical values, you can choose to show the distribution as a curve, with information on the min, max, and average values, or display it as a bar chart as well. To switch between the two displays, use or .

  

Single Table

At the center of the page, a sample of your table data is displayed as a spreadsheet that you can interact with. The main elements of this table view are the following:

• The row number: This number is a visual help to identify the content of a row, but does not work as an ID. It is not tied to the content of the row.

• The column title: Visible in the column header, it shows the name given to the column. It can be changed from the Functions panel or the column menu, using the Rename column function.

• The column menu, accessible by clicking . The following column actions are available:

  • Rename column to change the name of a column.

  • Duplicate column to duplicate a column and its content.

  • Filter column to start creating a filter on your data. For more information, see Filtering data.

  • Filter rows with empty values to isolate empty values in this column. For more information, see Filtering data.

  • Filter rows with null values to isolate null values in this column. For more information, see Filtering data.

  • Hide column to reduce the number of visible columns in your table. Use the Visible columns button to manage which column are visible.

  • Pin column to the left to keep a column visible on the left of the table when horizontally scrolling. Select Unpin column from the column menu to move it back to its original place in the table.

  • Delete column to remove a column and its content from the table.

  

• The column content: The actual values contained in each row of your columns, allowing you to explore, analyze and fix the content of the table.

  

Table recipe

The Table recipe panel is the place where you manage the source data, and the output you want to create, via the recipe and the target configuration. It contains the following elements:

• The source, to select the data you want to prepare. Expand the section to change the fields to load or the source file itself.

  

• The recipe, where the successive functions applied to your table are listed. Click a step to edit a function configuration, or delete it altogether.

  

• The target, to choose how and where to export the prepared data.

  

• The list of keyboard shortcuts, that you can expand or collapse.

  Keyboard shortcut	Action
  CTRL + Click	Select multiple columns
  CTRL + SHIFT + A	Select the inverse of the current column selection
  CTRL + SHIFT + Click	Select a range of columns
  CTRL + A	Select all columns
  CTRL + S	Search the functions
  CTRL + D	Highlight the source panel
  CTRL + G	Highlight the Filter button
  CTRL + C	Copy cell value
  CTRL + Z	Undo a recipe step
  CTRL + SHIFT + Z	Redo a recipe step
  CTRL + ENTER	Run the recipe