-
Print
-
DarkLight
-
PDF
Edit
Note: You must Create an Engineering flow prior to editing.
- An engineering flow can be edited by clicking on the edit icon at the engineering home page.
-
This brings up the flow-editing page where changes can be made.
-
Files can be dragged and dropped and functions are selected from the toolbar.
-
After selecting a function, a window pops up asking for details.
-
After applying changes you can preview the output by clicking on the preview button.
-
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