Search

Transform SQL Dataset

Articles

Edit SQL Dataset

The newly created SQL Dataset is displayed under the Datasets screen.
To view or edit the SQL Dataset, click the name of the Dataset in the Datasets screen.
The SQL dataset with manipulated data is displayed.

  1. Click the Image description icon on the right-hand panel and the following options are displayed.
    1. SQL Editor: You can modify the Dataset in SQL Editor to make changes in the data that is retrieved as per the requirements in further steps of automation.
    2. Description: You can add description using this option.
    3. Reload Dataset: You can use this option to get the dataset back without any filters or sorting.
  2. Click the Image description icon against each column to sort or filter the data in the column. Image description

SQL Editor Options

Click the SQL Editor Image description icon and select the SQL Dataset from left-hand panel to modify the Dataset.

  • Click the Image description icon to filter the data.
  • Click the Schema Edit Image description icon to edit the schema.
  • Click the SQL Query Editor Image description icon to view the SQL Query Editor with the table listed in the lower panel and Query above it.
  • Click the Image description icon to publish the Dataset.

Image description

Publish the Dataset after modification, so that the modified dataset can be used in automation tasks.

Schema Edit

Schema Edit is used to modify the schema of the dataset as per the requirement before publishing.
The data in the SQL Dataset can be cleansed or transformed as needed to use in the automation process. The following transformations can be done to make the data more usable:

  • Transform existing columns by making them Nullable, Hide, Duplicate, or Delete the column.
  • Add derived columns to add new rules to the data.
  • Transform the data in the existing columns using expressions.
  1. Click the Image description icon. A Schema popup window opens with all the columns of the selected dataset.
  2. Click the Image description icon to modify the schema. The data in the SQL Dataset can be transformed as needed to use in the automation process.
    To know more about how to transform SQL Dataset, click here.

SQL Query Editor

The right-hand panel of the page displays options to edit the schema Image description, toggle to SQL Editor Image description, and publish Image description.

Image description

Did you find what you were looking for?