Difference between revisions of "MetaData Process Rules"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| Line 1: | Line 1: | ||
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. | 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 | + | = Data Cleanup Functions = |
| − | + | * Delete | |
| − | + | * DeDupe | |
| − | |||
| − | + | = Maths functions = | |
| − | Maths functions | ||
| − | |||
* Add | * Add | ||
* Subtract | * Subtract | ||
| Line 17: | Line 14: | ||
* Numeric - Forces the value to be numeric. Defaults to 0 if string or unrecognised | * 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. | * Boolean - Forces the value to be Boolean. Defaults to false if unrecognised. | ||
| − | |||
| − | |||
= String Functions = | = String Functions = | ||
| Line 32: | Line 27: | ||
* Prepend - Add to the start 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 | * DateTime - Format the time in Universal Date Time format yyyy-mm-dd hh:mm:ss | ||
* Date - yyyy-mm-dd only | * Date - yyyy-mm-dd only | ||
| Line 44: | Line 37: | ||
* Percentage - Divide 1 by 2, output formatted number * 100, limit to 2 decimal places | * Percentage - Divide 1 by 2, output formatted number * 100, limit to 2 decimal places | ||
| − | + | = Data Cumulative Functions = | |
| − | |||
| − | |||
* Sum | * Sum | ||
* Count | * Count | ||
* IsUnique | * IsUnique | ||
| − | + | = Data Transformation Functions = | |
| − | |||
| − | |||
* Convert_Title | * Convert_Title | ||
* Convert_County | * Convert_County | ||
| Line 62: | Line 51: | ||
* Convert_DataField | * Convert_DataField | ||
| − | Data Transfer | + | = Data Transfer = |
| − | + | * CrossDatabase_Update | |
| − | + | * CrossDatabase_Insert | |
| − | |||
Revision as of 17:47, 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.
Contents
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
