Documentation - RestApp

Introduction
- Welcome
- Concepts

Get Started

Connectors
- MySQL
- MSSQL
- MongoDB
- PostgreSQL
- SFTP
- Google Drive
- Webhook
- Stripe
- Google Sheets
- Excel
- Files (JSON, TXT)
- Airtable

Pipeline (Modeling)
- Union
- Intersect
- Except
- Join
- Sort columns
- Windowing agg
- Windowing ranking
- Outliers detection STD
- Windowing analytical
- Outliers detection quantile
- Cube
- Outliers detection IQR
- Roll up
- Input
- Output
- Group by
- Pivot
- Plus
- Minus
- Multiply
- Divide
- Quotient
- Logical OR
- Logical XOR
- Regex match
- Regex replace
- Explode
- Explode outer
- Logical AND
- Cast (ChangeType)
- Add date
- Logical NOT
- Correlation
- Exponential
- Power
- Absolute
- Floor
- Ceil
- Square root
- Cubic root
- Date difference
- Between
- Concat
- Convert date
- Length
- Is numeric
- Trim (RemoveSpace)
- Left trim
- Right trim
- Encode
- Decode
- Sub string
- Split string
- Convert string to array
- Convert string to structure
- Rename column (Rename)
- Select column
- Drop column
- Add column
- Limit
- Sample
- Drop NA
- Fill NA
- Filter SQL
- Slice
- Unique
- Drop duplicates
- Cast to date
- Order
- Unpivot
- Correlation matrix
- Random column
- Normal distribution
- Normal distribution DF
- Uniform distribution DF
- JSON Normalize
- Handle array struct
- Modulo
- Logarithm
- Create date
- Round
- Trunc
- Capitalize
- Upper
- Lower
- Count
- Timestamp
- Sequence
- Column number
- Column name
- Is upper
- Is lower
- Array element at
- Subs
- bloc SQL
- If
- Var
- Sum
- Median
- Min
- Max
- Sequence Array
- Std Diff
- Average
- Skip
- Left Pad
- Right Pad
- Reverse
- Filter
- If Null
- Extract
- Transpose
- Webhook
- Count If

Automation
- Automate a pipeline

Domains
- Users
- Pipelines
- Connectors
- Settings

© 2023 documentator.io

Documentation - RestApp

Getting started

Order

Definition

Returns the table with sorted columnName (ascending/descending).

2 seconds estimated read time

Last updated 1 year ago