Datagration Knowledge Base

Back to home

Datagration Knowledge Base

P#

P#

Introduction to P#, Datagration's unique petro-technical scripting language.

Getting Started with P#

What is the autocomplete in P# scripts?

What is P#?

How do I write P# Scripts?

How do I make sure that no one can edit my P# script?

How do I use Placeholders in P# Scripts?

How do I know what's being changed on my scripts?

Reference Tables vs Scenarios

See more

Data Cleansing

How do I write a data Cleansing Script in P#?

What is data cleansing in PetroVisor?

String Functions

TimeStringSignal()

Upper()

Trim()

ToBoolean()

ToAggregation()

TimeSignal()

StringSignal()

StartOfDepth()

ResponseSurfaceScore()

ResponseSurfaceProbability()

ResponseSurfaceAggregationPoint()

ResponseSurfaceAggregation()

ResponseSurface()

PredictProbability()

Predictor()

OpportunitiesByName()

Mid()

Lower()

LastStringValue()

IsInsideDataGridCell()

EntitiesInsideDataGridCell()

EntitiesFromEntitySet()

EntitiesByName()

EndofDepth()

DepthSignal()

CurrentDataGridCell()

_List()

AggregateJSON()

_Hierarchy()

CurrentHierarchy()

ScenarioStringValue()

Signal()

NullString()

Concat()

CurrentEntity()

CurrentParent()

ParseJSON()

ToString()

Find()

Len()

Left()

Right()

See more

Scenario Functions

ScenarioEntities()

ScenarioScope()

ScenarioValue()

Regression Functions

RegressionParameter()

RegressionValue()

Placeholder Functions

_DateTime()

_Double()

_Entity()

_Signal()

_String()

See more

Neighborhood Functions

AggregateDataGrid()

DataGridCellValue()

CurrentRoot()

AggregateFromEntities()

AggregateIfTagged()

Neighbors()

PercentRank()

See more

Mathematical Functions

NumberOfPredictors()

NumberOfInputFeatures()

Ceiling()

Abs()

ACos()

ASin()

ATan()

Cos()

E()

Exp()

Floor()

LN()

Log()

LOG2()

Pi()

Power()

Random()

Root()

Round()

Sin()

Sqrt()

Tan()

Trunc()

See more

Logic Functions

Contains

EndsWith()

IF THEN ELSEIF ELSE

IIf

IsEntityType

IsNotNull

IsNull

IsTagged

StartsWith()

See more

Entities Function

EntitiesFromContext()

EntitiesFromIntersection()

EntitiesByHierarchy()

All()

BestChild()

BestChildren()

BestEntity()

EntitiesByAlias()

EntitiesByCondition()

EntitiesByDelimitedString()

EntitiesByParent()

EntitiesByParentTag()

EntitiesByTag()

EntitiesByType()

Siblings()

ValueForEntity()

See more

Moving Window Functions

MovingAvg

MovingChange

MovingDiff

MovingDiv

MovingMax

MovingMin

MovingOscillationCoefficient

MovingOutlier

MovingSlope

MovingStep

MovingSum

See more

Time and Date Functions

StartofTag()

CurrentScopeIncrement()

TagDuration()

EndOfTag()

CurrentScope

CurrentStep

Day

DayOfWeek

DayOfYear

DaysInMonth

DateDiff()

EndOf()

Hour

Millisecond

Minute

Month

Next

Now

Previous()

Second

Shift

StartOf()

ToDateTime

Today

Year()

ToTimeStep()

See more

Statistical Functions

MovingPercentile()

CumulativeByRank()

Mod()

Average

Count

Cumulative

First

HistoryCumulative

Last

Max

Median

Min

Mode

Normalize()

Percentile

StDev

Sum

Variance

See more

Economic Functions

IRR()

NPV()

Data Handling

NullDate()

FillGaps()

Null()

Replace()

Smooth()

ToDouble()

See more

Additional Functions

TablesIntersection() (deprecated)

TableKey() (deprecated)

IsOpportunity()

How do I use a depth dependent scope?

DepthValue()

DynaCard()

LastValue()

PVTValue()

Rank()

TableValue() (deprecated)

TableValueAggregated() (deprecated)

WorkspaceDictionary()

WorkspaceEnumeration()

WorkspaceList()

WorkspaceValue()

RefTableValueAggregatedAsString()

RefTableArea()

RefTableSlope()

RefTableKey()

RefTablesIntersection()

RefTableValueAsString()

RefTableLastTimeStamp()

See more

Directional Functions

CurrentScopeDepthIncrement()

CurrentDepthStep()

CoordinateCRS()

CoordinateDegree()

CoordinateUTM()

MinDistance()

ToDepthStep()

See more

Machine Learning Functions

DetectAnomaly()

DetectChangePoint()

DetectSpike()

Predict()

PredictScore()

Forecast()

See more

DCA Functions

DCAModelDate()

DCAModelParameter()

DCAModelValue()