Revision as of 03:00, 22 March 2014

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.

1 Data Cleanup Functions

• Delete
• DeDupe

2 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.

3 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

4 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

5 Data Cumulative Functions

• Sum
• Count
• IsUnique

6 Data Transformation Functions

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

7 Data Transfer

• CrossDatabase_Update
• CrossDatabase_Insert