- Release notes
- Getting started
- Installation
- Configuration
- Integrations
- Authentication
- Working with Apps and Discovery Accelerators
- AppOne menus and dashboards
- AppOne setup
- TemplateOne 1.0.0 menus and dashboards
- TemplateOne 1.0.0 setup
- TemplateOne menus and fashboards
- TemplateOne 2021.4.0 setup
- Purchase to Pay Discovery Accelerator menus and dashboards
- Purchase to Pay Discovery Accelerator Setup
- Order to Cash Discovery Accelerator menus and dashboards
- Order to Cash Discovery Accelerator Setup
- Basic Connector for AppOne
- SAP Connectors
- Introduction to SAP Connector
- SAP input
- Checking the data in the SAP Connector
- Adding process specific tags to the SAP Connector for AppOne
- Adding process specific Due dates to the SAP Connector for AppOne
- Adding automation estimates to the SAP Connector for AppOne
- Adding attributes to the SAP Connector for AppOne
- Adding activities to the SAP Connector for AppOne
- Adding entities to the SAP Connector for AppOne
- SAP Order to Cash Connector for AppOne
- SAP Purchase to Pay Connector for AppOne
- SAP Connector for Purchase to Pay Discovery Accelerator
- SAP Connector for Order-to-Cash Discovery Accelerator
- Superadmin
- Dashboards and charts
- Tables and table items
- Application integrity
- How to ....
- Working with SQL connectors
- Introduction to SQL connectors
- Setting up a SQL connector
- CData Sync extractions
- Running a SQL connector
- Editing transformations
- Releasing a SQL Connector
- Scheduling data extraction
- Structure of transformations
- Using SQL connectors for released apps
- Generating a cache with scripts
- Setting up a local test environment
- Separate development and production environments
- Useful resources
Record expressions
A record expression is an expression that is evaluated for each record. Each new expression adds a new column to the table.
A record expression calculates a value per record and consists of a set of operations and functions that can be applied to the data. This is similar to the use of functions in Excel cells.
Within a record expression, data source attributes can be referenced using their attribute name, which gets the value of that attribute for each record. Expressions can be saved and used in new expressions.
Amount / 100, where the expression is evaluated three times; once for each record.
The following expression contains a conditional check: “If the Amount is higher than 20,000, we want to return the Supplier, otherwise, we want to return the Invoice number”.
Below is an example of a dataset containing three records as the result of the expression:
if(Amount>20000, Supplier, text(Invoice_number)).
The expression is built up in the following manner:
Check if Amount > 20000
- If yes (= then), return Supplier(which is a text value)
-
If no (= else), convert Invoice_number to a text value (using the
text()function), and return the result of the conversion.The result of the expression has the same type (Text) for every record. Converting the Invoice_number to a text value unifies the types of the second (‘then’) and third (‘else’) arguments to theif()function, which must be of the same type.
null. Each function handles NULL values differently. For example, the expression null + 1 will return 1, because the plus operator will ignore NULL values. Also, the average of a set of values ignores the NULL values. However, the expression null mod 2 will return NULL, because the modulus operator treats NULL values as an identity.
