Build
      Back to home
      1. Datagration Knowledge Base
      2. Getting Started
      3. Build

      Tables

      View Data in a table format and prepare data for visualization tools.

      To view the data as a table, select table under Build in the Navigation Column. 

      There are two types of tables in PetroVisor:

      1. Pivot Tables:  Pivot Tables are a valuable tool for consolidating and organizing vast quantities of data into a format that is user-friendly and easy to comprehend.
      2. Reference Tables:  Reference Tables are a collection of key-value pairs that are linked to an entity, but they are not necessarily tied to a specific timestamp. The key and value columns in a reference table can have units associated with them, which makes it easier for automatic unit conversion to take place.

      This article will guide you through the following topics:

      Select a Table to View

      Create a new Pivot Table

      Create a new Reference Table

      Saving Reference Table Data from a P# script

      Reference Table P# Functions

       

      View a Table

      Search

      Filter

      Select a Table

      After selecting a table, the user can see different information.

      • Name - name of table
      • Last Saved - date last saved
      • Hierarchy - hierarchy used in table
      • Parents - parents of entity if applicable
      • Tags - classified events of a specific entity
      • Entity Type - table will populate entity type
      • Alias - table will populate alias if applicable
      • Opportunity - table will populate true if entity is an oppurtunity
      •  Options
        • Use P# script execution - use a script to execute the table
        • Skip Empty Rows - skip rows that are empty
        • Append Saved Data - append data with a later start date than the original start date, also works for steps per increment to generate tables with large sources of data

      The user can see the table code

      The Entity Sets associated with the table along with a map to visualize the location.

      The Scope of the table

      The Expression Builder is available to quickly build expressions.

      The user can also load prebuilt tables and modify as required.

      Create a new Pivot Table

      To Add a table select the green Add Table button on the top right.

      Name the Table.

      To create a table, three sections are needed, Table Columns, Entity Set, and Scope.

      The table columns can be typed to built using the Expression Builder.  The Expression Builder is on the top right of the screen.

      For each column, add the expression.  The example below shows adding the well name as a column.  

      Select Add Expression to add.

      Continue to add expressions.  The table below shows Well Name with Latitude and Longitude.

      Select the Entity Set.  The example below shows all active wells from the expression builder.

      For the Scope, Expression builder or load can be used.  The example shows "Load."

      Notice after selecting it populates the scope.

      Select Save to Save the Table.

      Select Save & Generate to save the table and view it.  

      To view, select View Saved.

       

      Create a New Reference Table

      To create a new table, go to the Tables section and click on the dropdown menu for Create Table.

      Once you have named the reference table, you can proceed to fill in the columns. Make sure to add the necessary columns as needed.

      Note:  The Reference Table Definition is added to the entire workspace, but the key-value pairs stored in a reference table will be associated to individual entities. To create a general collection of key-value pairs that will be associated to the entire workspace, create a Workspace Dictionary instead.

      Once you have finished adding the values, click on the Save button.
      To View the data, select View Data.
      The data will be shown.  
      Notice the option to Delete the data.

      Manually entering Reference Table data

      To manually enter data for a reference table

      • navigate to the Data page
      • change the mode to Reference Table
      • select an entity, a Reference Table Definition and optionally a timestamp
      • add new key-value-pairs to the reference table by pressing the add row button (+)
      • to remove a row, select the row and press the delete row button (trash can)
      • when finished adding/removing data, click the green "Save Data" button in the upper right.  

      Saving Reference Table Data from a P# script

      To save data to a Reference Table from P# simply add a saving-clause to the table definition.

      Mind the following conventions/restrictions:

      • The first column in the table will be considered the key column of the Reference Table
      • The second column in the table will be considered the value column of the Reference Table
      • If a date column is present in the P# table, it will be considered as specifying the timestamp for the reference table

       

      Reference Table related P# functions

      TableValue()

      Returns the value of the reference table at the given key. If the key is not available in the reference table, the value will be interpolated from the two nearest available key-value-pairs.

      TableKey()

      Returns the key for the specified exact, interpolated or extremum (min, max) value. If the specified condition is satisfied more than once, the first key is returned.

      TablesIntersection()

      Returns the point of intersection of the two specified Reference Tables for the current entity. Supported intersection return values are: “Max Key”, “Min Key”, “Max Value”, “Min Value”.

      TableValueAggregated()

      Returns the aggregated value of the Reference Table for the current entity. This function also features an overload to calculate the slope at a given key of the Reference Table.