Table Analytics Package

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