Install
Download the Package and follow the instructions to install it in your AAE Control Room.
Table Analytics Package
Provide a package to perform analytics on tables for purposes of identifying discrepancies and speeding reconciliation activities
Top Benefits
- Speed reconciliation
- Improve data quality
- Reduce steps required in bot development
- Adds computed columns to tables
- Allows dynamic creation of records
Actions
- Provides differences across 2 tables
- Provides validation of numerical data
- Provides validation of string data based on regular expressions
- Allows you to add a computed column to a table based on existing columns
- Allows dynamic creation of record objects for insertion into Data Tables
Foundation for analyzing 2 tables and performing complex ops beyond JOIN
Diff - compares two tables with keys provided for each and finds differences. Returns a table with column and value for non-matching data elements
NumberValidator - validates numbers 3 ways - Range, Type (Positive, Negative, Whole, Decimal) or Comparison (, =, !=)
StringValidator - sees if the string matches the RegEx pattern
Validators use the exception handling pattern, so they must be wrapped in a try/catch block or the bot will terminate.
Add a computed column based on existing columns by their index. For example [1]*20 says to take the value of the cell in the 2nd column and multiply it by 20. If [1] is not numeric or the formula cannot be read as a mathematical statement the resulting field will say "Improperly Formed Formula"
For support: @jpmorgenthal on Twitter