Create Engineering Flow

Create

1. Click on Create button.

2. A popup window will appear asking for more details.
3. Input flow name and flow description.
4. Click on Save button.

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.
   

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

6. 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

5. All created flows will be shown on the engineering home page.
   6. You can edit,view and delete a created engineering flow.