Edit Engineering Flow

Edit

1. An engineering flow can be edited by clicking on the edit icon at the engineering home page.

2. This brings up the flow-editing page where changes can be made.

3. Files can be dragged and dropped and functions are selected from the toolbar.

4. After selecting a function, a window pops up asking for details.

6. After applying changes you can preview the output by clicking on the preview button.
   

7. The preview will be displayed in a popup window.
   

   • Click on the save button, to save the engineering flow.
   • Click on the close button to close the editor screen.

Engineering functions:

Joins

* Left Join : Returns all rows from the left table, even if there are no matches in the right table.
* Right Join : Returns all rows from the right table, even if there are no matches in the left table.
* Inner Join : Returns rows when there is a match in both tables.
* Right Outer Join : Returns all records when there is a match in left or right table records.
Aggregate : Aggregate functions that operate on sets of values. They are often used with a GROUP BY to Aggregate values into subsets.
* Sum : Return the sum
* Average: Return the average value
* Count: Return a count of the number of rows returned
* Minimum: Return the minimum value
* Median: returns the middle value.

PGSQL : Stores the output data in PGSQL data base