Difference between revisions of "MetaData Process Rules"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| Line 12: | Line 12: | ||
* Subtract | * Subtract | ||
* Multiply | * Multiply | ||
| − | * Divide | + | * Divide - Divide by 0 is always calculated to 0 for reporting purposes |
| − | * Modulus Modulus maths, leaves the remainder | + | * Modulus - Modulus maths, leaves the remainder |
| − | * Positive Always makes a value positive | + | * Positive - Always makes a value positive |
| − | * 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 = |
| − | * Replace | + | * Replace - Replaces one string with another |
| − | * RemoveNumbers Removes all numbers from the values | + | * RemoveNumbers - Removes all numbers from the values |
| − | * Trim | + | * Trim - Removes leading and trailing spaces |
| − | * TitleCase | + | * TitleCase - Used for tidying up names. Capitalises the first letter of each word. |
| − | * SentenceCase | + | * SentenceCase - Reformats the data into sentence case. |
| − | * Concat | + | * Concat - Combines two strings in the order supplied |
| − | * Encapsulate | + | * Encapsulate - Surround a string with the values provided |
| − | * Fixed | + | * Fixed - Extracts a fixed amount from the string |
| − | * Append | + | * Append - Add to the end of the string |
| − | * Prepend | + | * Prepend - Add to the start of the string |
| − | ==Date | Time Functions | + | == Date | Time Functions == |
| − | * DateTime | + | * DateTime - Format the time in Universal Date Time format yyyy-mm-dd hh:mm:ss |
| − | * Date | + | * Date - yyyy-mm-dd only |
| − | * Time | + | * Time - hh:mm:ss only |
| − | * Zulu | + | * Zulu - Zyyyy-mm-ddThh:mm:ss |
| − | * ReportTimeToSeconds Converts report time to a seconds value | + | * ReportTimeToSeconds - Converts report time to a seconds value |
| − | * TimeToSeconds | + | * 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 | + | * SecondsToReportTime - When using comparison dates, after subtractions, converts to a report time format |
| − | * Percentage | + | * Percentage - Divide 1 by 2, output formatted number * 100, limit to 2 decimal places |
| − | ===Data Cumulative Functions | + | === Data Cumulative Functions === |
* Sum | * Sum | ||
* Count | * Count | ||
| Line 52: | Line 52: | ||
| − | + | ||
| − | ==== | + | ==== Data Transformation Functions ==== |
* Convert_Title | * Convert_Title | ||
* Convert_County | * Convert_County | ||
Revision as of 17:45, 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
Contents
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.
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
3.1 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
3.1.1 Data Cumulative Functions
- Sum
- Count
- IsUnique
3.1.1.1 Data Transformation Functions
- Convert_Title
- Convert_County
- Convert_Country
- Convert_StaffId
- Convert_DepartmentId
- Convert_SecurityGroupId
- Convert_DataField
Data Transfer
3.1.1.1.1 ==================
Function: CrossDatabase_Update Function: CrossDatabase_Insert
