Skip to content
Product
Pricing
Solutions
Transfer Pricing for Goods & Services
Customer & Product Profitability
Bill of Materials Costing and Forecasting
Cost to Serve
Robotic Process Automation
Marketing & Sales
Resources
Documentation
API
Help
Manage Account
Company Blog
Engineering Blog
Global Datacenters
Terms of Service
Privacy Policy
Security
Sign-In
Search for:
Product
Pricing
Solutions
Transfer Pricing for Goods & Services
Customer & Product Profitability
Bill of Materials Costing and Forecasting
Cost to Serve
Robotic Process Automation
Marketing & Sales
Resources
Documentation
API
Help
Manage Account
Company Blog
Engineering Blog
Global Datacenters
Terms of Service
Privacy Policy
Security
Sign-In
Search for:
Product
Pricing
Solutions
Transfer Pricing for Goods & Services
Customer & Product Profitability
Bill of Materials Costing and Forecasting
Cost to Serve
Robotic Process Automation
Marketing & Sales
Resources
Documentation
API
Help
Manage Account
Company Blog
Engineering Blog
Global Datacenters
Terms of Service
Privacy Policy
Security
Sign-In
PlaidCloud
Home
/
PlaidCloud
Home
Documentation
PlaidCloud
PlaidCloud
Getting Started
Dashboards
Learning Dashboard
Dashboards
Documents
Temporary Storage
Managing Accounts
File and Folder Management
Document
Identity
Member Management
Member Authentication
Managing Security
Identity
Organization & Workspaces
Workspaces
Organizations and Workspaces
Organizations
Projects
Projects
Project Log
Managing Tables
Managing Projects
Managing Hierarchies
Managing Data Editors
Archives
Tools
Tools
PlaidLink Agents
Message Queues
Event Scheduler
Data Connections
Workflows
Workflows
Wait
User Defined Transform – Workflow Step Definition
Transforms – Workflow Control
Transforms – User Defined
Transforms – Table
Transforms – SAP PCM Integration
Transforms – SAP Integration
Transforms – Report
Transforms – Remote Operations
Transforms – Other
Transforms – Notification
Transforms – Import
Transforms – Export
Transforms – Document Management
Transforms – Allocation
Table Union Distinct
Table Union All
Table Split
Table Pivot
Table Outer Join
Table Melt
Table Lookup
Table Loader
Table Inner Join
Table In-Place Update
Table In-Place Delete
Table Faker
Table Extract
Table Data Selection
Table Copy
Table Clear
Table Anti Join
Stop Workflow
Stop PCM Model Calculation
Stop Loop
Source Table Slicing (Limit)
Source and Target
Set Workflow Variable
Set Project Variable
Select Subset of Source Data
Select Subset of Final Data
Run Workflow Conditionally
Run Workflow
Run SAP PCM Hyper Loader
Run SAP PCM Console Job
Run Remote Python
Run App Operation
Report Single
Report Batch
Rename Workflow
Rename SAP PCM Model
Rename Document File
Rename Document Directory
Pass
Output File Type
Notify Via Web Hook
Notify Via Twitter
Notify Via SMS
Notify Via Log
Notify Via Email
Notify Distribution Group
Notify Agent
Machine Learning
Import XML
Import Table Archive
Import Stata
Import SQL
Import SPSS
Import SAS7BDAT
Import Quandl
Import JSON
Import HTML
Import HDF
Import Google Spreadsheet
Import Google BigQuery
Import Fixed Width
Import Excel
Import CSV
Final Data Table Slicing (Limit)
Export XML
Export to Json
Export to HDF
Export to Google Spreadsheet
Export to Google BigQuery
Export to Excel
Export to CSV
Export Table Archive
Export Stata
Export SQL
Export SPSS
Export Quandl
Export HTML
Duplicates
Document Text Substitution
Document – Remote Rename File
Document – Remote Import File
Document – Remote Export File
Document – Remote Delete File
Delete Workflow
Delete SAP PCM Model
Delete Document File
Delete Document Directory
Data Filters
Create Workflow
Create SAP PCM Model
Create Document Directory
Copy Workflow
Copy SAP PCM Version
Copy SAP PCM Period
Copy SAP PCM Model
Copy Document File
Copy Document Directory
Convert Document Encoding to UTF-8
Convert Document Encoding to UTF-16
Convert Document Encoding to ASCII
Convert Document Encoding
Common Transform Elements
Clear Workflow Log
Call SAP RFC
Call SAP Master Data Table RFC
Call SAP General Ledger Posting
Call SAP Financial Document Attachment
Calculate PCM Model
Allocation Split Filter
Allocation Split
Aggregation
Agent Remote Import Table into SQL Database
Agent Remote Export of SQL Result
Agent Remote Execution of SQL
Jupyter
JupyterLab
Jupyter Notebook
Jupyter Console
Jupyter
Expression & Filter Functions | General Usage
Text Expressions
PostGIS
Mathematics Expressions
Filters
Expressions
Dates and Time Expressions
Data Type Expressions
Conditionals
Expressions & Filter Functions | Arrays
func.unnest
func.string_to_array
Expressions & Filter Functions | Conditions
or_
not_
func.coalesce
case
and_
Expressions & Filter Functions | Conditions on Columns
column.startswith
column.notlike
column.notin_
column.notilike
column.like
column.isnot
column.is_
column.in_
column.ilike
column.endswith
column.contains
column.between
column.any_
Expressions & Filter Functions | Conversions
func.to_timestamp
func.to_number
func.to_date
func.to_char
cast
Expressions & Filter Functions | Dates
func.transaction_timestamp
func.timeofday
func.statement_timestamp
func.now
func.justify_interval
func.justify_hours
func.justify_days
func.isfinite
func.extract
func.date_trunc
func.date_part
func.current_timestamp
func.current_time
func.current_date
func.clock_timestamp
func.age
Expressions & Filter Functions | JSON
json_object_keys
json_extract_path_text
json_extract_path
json_each_text
json_each
json_array_elements
array_to_json
Expressions & Filter Functions | Math
func.width_bucket
func.trunc
func.sqrt
func.sign
func.setseed
func.safe_divide
func.round
func.random
func.radians
func.power
func.pi
func.mod
func.log
func.ln
func.least
func.greatest
func.floor
func.exp
func.degrees
func.ceiling
func.ceil
func.cbrt
func.abs
Expressions & Filter Functions | PostGIS
func.ST_ZMin
func.ST_Zmflag
func.ST_ZMax
func.ST_Z
func.ST_YMin
func.ST_YMax
func.ST_Y
func.ST_XMin
func.ST_XMax
func.ST_X
func.ST_WKTToSQL
func.ST_WKBToSQL
func.ST_Within
func.ST_Union
func.ST_UnaryUnion
func.ST_TransScale
func.ST_Translate
func.ST_Transform
func.ST_Touches
func.ST_SymDifference
func.ST_SwapOrdinates
func.ST_Summary
func.ST_Subdivide
func.ST_StartPoint
func.ST_SRID
func.ST_Split
func.ST_SnapToGrid
func.ST_Snap
func.ST_SimplifyVW
func.ST_SimplifyPreserveTopology
func.ST_Simplify
func.ST_ShortestLine
func.ST_ShiftLongitude
func.ST_SharedPaths
func.ST_SetSRID
func.ST_SetPoint
func.ST_SetEffectiveArea
func.ST_Segmentize
func.ST_Scale
func.ST_RotateZ
func.ST_RotateY
func.ST_RotateX
func.ST_Rotate
func.ST_Reverse
func.ST_RemoveRepeatedPoints
func.ST_RemovePoint
func.ST_RelateMatch
func.ST_Relate
func.ST_Project
func.ST_Polygonize
func.ST_PolygonFromText
func.ST_Polygon
func.ST_PointOnSurface
func.ST_PointN
func.ST_PointInsideCircle
func.ST_PointFromWKB
func.ST_PointFromText
func.ST_PointFromGeoHash
func.ST_Point
func.ST_Perimeter2D
func.ST_Perimeter
func.ST_PatchN
func.ST_Overlaps
func.ST_OrderingEquals
func.ST_OffsetCurve
func.ST_NumPoints
func.ST_NumPatches
func.ST_NumInteriorRings
func.ST_NumInteriorRing
func.ST_NumGeometries
func.ST_NRings
func.ST_NPoints
func.ST_Node
func.ST_NDims
func.ST_Multi
func.ST_MPolyFromText
func.ST_MPointFromText
func.ST_MLineFromText
func.ST_MinimumBoundingCircle
func.ST_MemUnion
func.ST_MemSize
func.ST_MaxDistance
func.ST_MakeValid
func.ST_MakePolygon
func.ST_MakePointM
func.ST_MakePoint
func.ST_MakeLine
func.ST_MakeEnvelope
func.ST_MakeBox2D
func.ST_M
func.ST_LongestLine
func.ST_LocateBetweenElevations
func.ST_LocateBetween
func.ST_LocateAlong
func.ST_LineToCurve
func.ST_LineSubstring
func.ST_LinestringFromWKB
func.ST_LineMerge
func.ST_LineLocatePoint
func.ST_LineInterpolatePoint
func.ST_LineFromWKB
func.ST_LineFromText
func.ST_LineFromMultiPoint
func.ST_LineFromEncodedPolyline
func.ST_LineCrossingDirection
func.ST_LengthSpheroid
