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#?

What are the Datagration Scripting Best Practices?

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?

See more

Data Cleansing

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

What is data cleansing in PetroVisor?

String Functions

CurrentHierarchy()

AggregateJason()

ScenarioStringValue()

Signal()

NullString()

Concat()

CurrentEntity()

CurrentParent()

ParseJSON()

ToString()

See more

Scenario Functions

ScenarioEntities()

ScenarioScope()

ScenarioValue()

Regression Functions

RegressionParameters()

RegressionValue()

Placeholder Functions

_DateTime()

_Double()

_Entity()

_Integer()

_Signal()

_String()

See more

Neighborhood Functions

AggregateFromEntitites

AggregateGrid

AggregateIf

AggregateIfTagged

AggregateNeighbors

AggregateSiblings

AggregateVoronoiCells

CountChildrenByTag

Neighbors

PercentRank

See more

Mathematical Functions

Aggregations

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

EndWith()

IF THEN ELSEIF ELSE

IIf

IsChildTagged

IsEntityType

IsNotNull

IsNull

IsParentTagged

IsTagged

StartsWith()

See more

Entities Function

EntitiesFromIntersection()

EntitiesByHierarchy()

All

BestChild

BestChildren

BestEntity

EntitiesByAlias

EntitiesByCondition()

EntitiesByDelimitedString

EntitiesByParent()

EntitiesByParentTag

EntitiesByTag

EntitiesByType

EntitiesByValue

EntitiesInsidePolygon

EntityFromContext

NameContains

NameEndsWith

NameStartsWith

Siblings

ValueForEntity

See more

Moving Window Functions

MovingAvg

MovingChange

MovingDiff

MovingDiv

MovingMax

MovingMin

MovingOscillationCoefficient

MovingOutlier

MovingSlope

MovingStep

MovingSum

WeightedMovingAvg

See more

Time and Date Functions

StartofTag()

CurrentScopeIncrement()

TagDuration()

StartOfPreviousTag()

EndOfPreviousTag()

EndOfNextTag()

StartOfNextTag()

EndOfTag()

CurrentScope

CurrentStep

Day

DayOfWeek

DayOfYear

DaysInMonth

DateDiff

EndOf()

EndOfFirstTag

EndOfLastTag()

Hour

Millisecond

Minute

Month

Next

Now

Previous()

Second

Shift

StartOf()

StartOfFirstTag

StartOfLastTag

ToDateTime

Today

Year()

ToTimeStep()

See more

Statistical Functions

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()

Replace()

FillGaps()

Null()

NullMinus()

NullPlus()

Replace()

Smooth()

ToDouble()

ToInteger()

See more

Additional Functions

IsOpportunity()

TablesIntersection()

TableKey()

How do I use a depth dependent scope?

DepthValue()

DynoCard()

IsChildTagged()

LastValue()

PVTValue()

Rank()

TableValue()

TableValueAggregated()

ValueFromChildren()

ValueFromParent()

WorkspaceDictionary()

WorkspaceEnumeration()

WorkspaceList()

WorkspaceValue()

See more

Directional Functions

CoordinateCRS()

CoordinateDegree()

CoordinateUTM()

IsInsidePolygon()

MinDistance()

MinDistanceToPolygon()

ToDepthStep()

See more

Machine Learning Functions

DetectAnomaly()

DetectChangePoint()

DetectSpike()

Predict()

PredictScore()

Forecast()

See more

Voronoi

AggregateVoronoiCell()

VoronoiArea()

VoronoiCellEntitiesCount()

DCA Functions

DCAModelDate()

DCAModelParameter()

DCAModelValue()