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

1 ==================

Function: Delete Function: DeDupe

Maths functions

2 ==================

• 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

3 ==================

• 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

4 ==================

• 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

5 ==================

• Sum • Count • IsUnique

Data Transformation Functions

6 ==================

• Convert_Title • Convert_County • Convert_Country • Convert_StaffId • Convert_DepartmentId • Convert_SecurityGroupId • Convert_DataField

Data Transfer

7 ==================

Function: CrossDatabase_Update Function: CrossDatabase_Insert