Search

Transform SQL Dataset

Articles

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.

View SQL Query

Click the Image description icon to view the SQL Query Editor with the table listed in the lower panel and Query above it.

The right-hand panel of the page display options to edit the schema, toggle to Dataset view, and publish.

Image description

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 Query in SQL Query Editor to make changes in the data that is retrieved as per the requirements in further steps of automation.
      Click the SQL Editor Image description icon and select the SQL Dataset from left-hand panel to modify the Query. Always publish the Dataset after modifying the query, so that the modified dataset can be used in automation tasks.

    2. Dataset Schema: Click the Dataset Schema Image description icon to edit the schema.

    3. Description: You can add description using this option.

    4. Reload Dataset: You can reload the dataset using this option. You can also use Dataset Refresh node to reload the dataset.

  2. Click the Image description icon against each column to sort or filter the data in the column. Image description

Did you find what you were looking for?