Add expression-based columns

 

1. Click the Data Wizard button at the bottom of the PC Mapping page.

2. In the dialog, click + to add a row in the top table for defining an equation.

3. In the Column Name cell, enter the header for the new column.

4. In the Expression cell, type an expression using column headers and operators.
   Formulas include:
   LEN(expression)
   ISNULL(expression, replacementvalue)
   IIF(expr, truepart, falsepart)
   TRIM(expression)
   SUBSTRING(expression, start, length)
   Wildcard Characters ("ItemName LIKE '*product*'", "ItemName LIKE '*product'", "ItemName LIKE 'product*'")
   
   Operators include:
   <, <=, =, <>, =, IN, LIKE
   + (append)
   - (subtraction)
   * (multiplication)
   / (division)
   % (modulus)

5. Click Execute to apply the expression and add the results as a new, appended column in the Mas­ter PC Worksheet.

Click X to remove the associated row from the table (the appended column is also removed from the Worksheet.

Expressions can be saved as to a file (.expr) using the Save button and then reused later using the Load button.

---

Last modified date:7/9/20

Legal Notice | Contact Certara
© 2020 Certara USA, Inc. All rights reserved.