Difference between revisions of "MetaData Process Rules"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (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...") |
Philip Lacey (talk | contribs) |
||
| Line 9: | Line 9: | ||
Maths functions | 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 | + | ===Data Cumulative Functions |
| − | + | * Sum | |
| − | + | * Count | |
| − | + | * IsUnique | |
| − | |||
Data Transformation Functions | Data Transformation Functions | ||
============================== | ============================== | ||
| − | + | * Convert_Title | |
| − | + | * Convert_County | |
| − | + | * Convert_Country | |
| − | + | * Convert_StaffId | |
| − | + | * Convert_DepartmentId | |
| − | + | * Convert_SecurityGroupId | |
| − | + | * Convert_DataField | |
Data Transfer | Data Transfer | ||
Revision as of 16:42, 12 March 2013
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
- 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
3 ==================
- Convert_Title
- Convert_County
- Convert_Country
- Convert_StaffId
- Convert_DepartmentId
- Convert_SecurityGroupId
- Convert_DataField
Data Transfer
4 ==================
Function: CrossDatabase_Update Function: CrossDatabase_Insert
