Edit Engineering Flow
  • 06 May 2021
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Edit Engineering Flow

  • Dark
    Light
  • PDF

Edit

Note: You must Create an Engineering flow prior to editing.

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

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


Was this article helpful?