MetaData Process Rules

MetaData Process rules are rules that allow for the processing of raw data. There are quite a number of rules and parameters used for each rule. Below is a list of the rules and how each one is set up.

= Data Cleanup Functions =
 * Delete
 * DeDupe

= Maths functions =
 * Add
 * Subtract
 * Multiply
 * Divide - Divide by 0 is always calculated to 0 for reporting purposes
 * Modulus - Modulus maths, leaves the remainder
 * Positive - Always makes a value positive
 * Numeric - Forces the value to be numeric. Defaults to 0 if string or unrecognised
 * Boolean - Forces the value to be Boolean. Defaults to false if unrecognised.

= String Functions =
 * Replace - Replaces one string with another
 * RemoveNumbers - Removes all numbers from the values
 * Trim - Removes leading and trailing spaces
 * TitleCase - Used for tidying up names. Capitalises the first letter of each word.
 * SentenceCase - Reformats the data into sentence case.
 * Concat - Combines two strings in the order supplied
 * Encapsulate - Surround a string with the values provided
 * Fixed - Extracts a fixed amount from the string
 * Append - Add to the end of the string
 * Prepend - Add to the start of the string

= Date | Time Functions =
 * DateTime - Format the time in Universal Date Time format yyyy-mm-dd hh:mm:ss
 * Date - yyyy-mm-dd only
 * Time - hh:mm:ss only
 * Zulu - Zyyyy-mm-ddThh:mm:ss
 * ReportTimeToSeconds - Converts report time to a seconds value
 * TimeToSeconds - For normal dates, convert to a base second time for comparisons
 * SecondsToReportTime - When using comparison dates, after subtractions, converts to a report time format
 * Percentage - Divide 1 by 2, output formatted number * 100, limit to 2 decimal places

= Data Cumulative Functions =
 * Sum
 * Count
 * IsUnique

= Data Transformation Functions =
 * Convert_Title
 * Convert_County
 * Convert_Country
 * Convert_StaffId
 * Convert_DepartmentId
 * Convert_SecurityGroupId
 * Convert_DataField

= Data Transfer =
 * CrossDatabase_Update
 * CrossDatabase_Insert