Create Engineering Flow
  • 20 Sep 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Create Engineering Flow

  • Dark
    Light
  • PDF

Create

1. Click on Create button.

image.png

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

image.png

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

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

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

image.png

  1. After applying changes you can preview the output by clicking on the preview button.
    image.png

  2. The preview will be displayed in a popup window.
    image.png

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

image.png

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.

image.pngPGSQL : Stores the output data in PGSQL data base

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