Dataset node is used to retrieve data from datasets using a query. The query editor supports ANSI SQL standard queries.

For Jiffy table and Document table, it is recommended to use Jiffy Select and Jiffy Insert/Update nodes.

Query Tab of Dataset Node

Double click the Dataset node and click the Query tab.

1. Specify query to be executed in the Query field.
   Query must be in the format: Select * from `/<app_group>/<app>/<dataset_name>` where <column_name> = <‘value’>.

   To select the columns from Customers dataset where the value in the column LastName is Smith, the query is:
   Select * from `/Human Resource/Administration/EmployeeDetails.csv` where LastName ='Smith';

2. Specify column names to display in the result set in Columns in result set (space separated) field.
   

   The specified names must be space-separated.

Properties of the Dataset Node

1. Navigate to Properties and enter Name and Description.
2. Enable Mark run Failure on Node Fail, Continue on no result? and Iterate on this node’s output? options as required.

Result of Execution of Dataset Node

After executing the task, the Result of Execution window displays the following tabs:

• Inputs: The query executed is displayed.
• Output: The output of the executed query consisting of columns selected in Columns in result set (space separated) field are displayed.
  Click the Iteration # to see details of each iteration.
• Run Info: The information of the run such as Run ID, Sequence Number, Iteration ID, Iteration Start Time, Iteration End Time, Iteration Time(in seconds), and Total Node Execution Time(in seconds) are displayed.