Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
Created page with "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..."
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
==============================
Function: Delete
Function: 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
==============================
Function: CrossDatabase_Update
Function: CrossDatabase_Insert
Data Cleanup Functions
==============================
Function: Delete
Function: 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
==============================
Function: CrossDatabase_Update
Function: CrossDatabase_Insert
