Search

Data Manipulation

Articles

The following sample task is created using the Data Nodes namely, Jiffy Select, Unlock Row, Jiffy Insert Update, Delete Row and Dataset nodes to automate the following process:

  1. Select data from a table.
  2. Unlock the rows of the table.
  3. Duplicate the data in the table or insert the obtained data into a different table.
  4. Delete rows from table where the data was inserted.
  5. Get the data from the dataset for further use in the task.

Do the following to automate the above process:

  1. In the Task Design screen, click on the << icon present on the right-hand side toolbar to expand the Nodes section.
  2. Drag and drop the Jiffy Select, Unlock Row, Jiffy Insert Update, Delete Row and Dataset nodes respectively from the Data Nodes section and align them in the following order: Image description

    Make sure that the Task Design screen is in Edit mode (the Edit button must be highlighted in green colour).

  3. Double-click on the Jiffy Select node and specify the properties. Image description
  4. To unlock the rows, double-click on the Unlock Row node and specify the properties. Image description
  5. Double-click on the line between the Jiffy Select and the Unlock Row nodes to view the Edit Mapping Data window.
  6. Select the UUID field (1) from the left hand send section, click on the UUID field (2) in the right hand section and click on the Element Map (3) button. Now, the UUID is mapped to the Unlock Row node (4) and the mapped row is unlocked. Image description
  7. The data fetched from the Jiffy Select node can be mapped to Jiffy Insert Update nodes and so the data can be duplicated in the existing table or saved in another table. To do this, double-click on the Jiffy Insert Update node and specify the properties. Image description
  8. Double-click on the line between the Unlock Row and the Jiffy Insert Update nodes to view the Edit Mapping Data window.
  9. Select the Jiffy Select node in the dropdown(5). Select the UUID and the Name fields (6) from the left hand send section, click on the ADD button (7). Now the data is mapped to the Jiffy Insert Update node (8). Image description
  10. To insert the mapped data into a table, select the mapped fields in the Variables dropdown in the properties section of the Jiffy Insert Update node. Image description
  11. To delete the duplicated rows, double-click on the Delete Row node and specify the properties. Image description
  12. Double-click on the line between the Jiffy Insert Update and the Delete Row nodes to view the Edit Mapping Data window.
  13. Select the Jiffy Insert Update node in the dropdown(9). Select the UUID field (10) from the left hand send section, click on the UUID field (11) in the right hand section and click on the Element Map (12) button. Now, the input variable is mapped to the Delete Row node (13). Image description
  14. To get the data from the dataset to use it further in the task, double-click on the Dataset node and specify the properties. Image description
  15. Write an SQL query in the Query tab (14) of the Dataset node to fetch the data from the dataset. Type the name of the columns in the table from which the data is to be fetched in the Columns in result set (space separated) field (15). Image description
Did you find what you were looking for?