This article outlines how to use Flows to perform a simple operation on a points database. This example uses three flows building blocks:

  • PointsInput
  • PointsMath
  • PointsOutput

The assembled flow is shown below:

In the PointsInput you select a points database. In this case I have selected a small database shown below.

In this example, my PHIT_CORE property is in decimal, and I would like it to be in percent. Instead of going back to Excel or a similar outside editor, I have chosen to do this in Flows.

In the PointsMath I use the following equation:

PhiT_pct = PHIT_CORE*100

PhiT_pct is the column I am creating and PHIT_CORE is my existing column name. Note that you can use multiple columns in your equation if desired (e.g., add two columns together).

In the PointsOutput I provide a name for the new points database I wish to create. A screenshot of the updated database is shown below:

The new column has the exact name we gave it in the PointMath block and it has been multiplied by 100.

Categories: flowsHelp