- 18 Jul 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
Create Engineering Flow
- Updated on 18 Jul 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
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.
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
- All created flows will be shown on the engineering home page.
6. You can edit,view and delete a created engineering flow.