Difference between revisions of "MetaData Process Rules"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| Line 34: | Line 34: | ||
| String || Set Value || [[MetaData_-_Processing_Rules_-_String_Management#Set_Value|Link]] | | String || Set Value || [[MetaData_-_Processing_Rules_-_String_Management#Set_Value|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Mathematical || [[MetaData_-_Processing_Rules_-_Mathematical_Functions|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Mathematical | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Mathematical_Functions|Link]] | ||
|- | |- | ||
| Mathematical || Addition || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Addition|Link]] | | Mathematical || Addition || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Addition|Link]] | ||
| Line 58: | Line 60: | ||
| Mathematical || Group Sum || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Sum|Link]] | | Mathematical || Group Sum || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Sum|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Date Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Date Time | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Date_and_Time_Management|Link]] | ||
|- | |- | ||
| Date Time || Date || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date|Link]] | | Date Time || Date || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date|Link]] | ||
| Line 80: | Line 84: | ||
| Date Time || Month To number || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Month_To_number|Link]] | | Date Time || Month To number || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Month_To_number|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Data || [[MetaData_-_Processing_Rules_-_Data_Management|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Data | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Data_Management|Link]] | ||
|- | |- | ||
| Data || Deletion || [[MetaData_-_Processing_Rules_-_Data_Management#Deletion|Link]] | | Data || Deletion || [[MetaData_-_Processing_Rules_-_Data_Management#Deletion|Link]] | ||
| Line 88: | Line 94: | ||
| Data || Flag Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Flag_Duplicate_Records|Link]] | | Data || Flag Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Flag_Duplicate_Records|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Conversion || [[MetaData_-_Processing_Rules_-_Data_Conversion|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Conversion | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Data_Conversion|Link]] | ||
|- | |- | ||
| Conversion || Convert Data field || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Data_field|Link]] | | Conversion || Convert Data field || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Data_field|Link]] | ||
| Line 96: | Line 104: | ||
| Conversion || Convert Client Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Client_Id|Link]] | | Conversion || Convert Client Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Client_Id|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || Cross Form || [[MetaData_-_Processing_Rules_-_Cross_Form|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | Cross Form | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_Cross_Form|Link]] | ||
|- | |- | ||
| Cross Form || Copy To Destination || [[MetaData_-_Processing_Rules_-_Cross_Form#Copy_To_Destination|Link]] | | Cross Form || Copy To Destination || [[MetaData_-_Processing_Rules_-_Cross_Form#Copy_To_Destination|Link]] | ||
| Line 108: | Line 118: | ||
| Cross Form || Cross Form Update Smart || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Smart|Link]] | | Cross Form || Cross Form Update Smart || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Smart|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || CCL Specific || [[MetaData_-_Processing_Rules_-_CCL_Specific|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | CCL Specific | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_CCL_Specific|Link]] | ||
|- | |- | ||
| CCL Specific || Insert Into CCL Simple || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_Into_CCL_Simple|Link]] | | CCL Specific || Insert Into CCL Simple || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_Into_CCL_Simple|Link]] | ||
| Line 114: | Line 126: | ||
| CCL Specific || Insert From CCL Custom || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_From_CCL_Custom|Link]] | | CCL Specific || Insert From CCL Custom || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_From_CCL_Custom|Link]] | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || QA || [[MetaData_-_Processing_Rules_-_QA_Specific|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library |
| + | | style="color:green; background-color:#ffffcc;" | QA | ||
| + | | style="color:green; background-color:#ffffcc;" | [[MetaData_-_Processing_Rules_-_QA_Specific|Link]] | ||
|- | |- | ||
| QA || Cross Database QA Fail All Check || [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check|Link]] | | QA || Cross Database QA Fail All Check || [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check|Link]] | ||
Revision as of 23:15, 7 February 2017
1 Overview
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. There is also a link off to the reference document for that function.
1.1 String Management
| Type | Function | Link |
|---|---|---|
| Library | String | Link |
| String | Append | Link |
| String | Prepend | Link |
| String | Encapsulate | Link |
| String | Remove Numbers | Link |
| String | Strip Tags | Link |
| String | Replace | Link |
| String | Concatenation | Link |
| String | Read From | Link |
| String | Read Until | Link |
| String | Set Value | Link |
| Library | Mathematical | Link |
| Mathematical | Addition | Link |
| Mathematical | Subtraction | Link |
| Mathematical | Multiplication | Link |
| Mathematical | Division | Link |
| Mathematical | Modulus | Link |
| Mathematical | Numeric | Link |
| Mathematical | Summation | Link |
| Mathematical | Count | Link |
| Mathematical | Is Unique | Link |
| Mathematical | Group Count | Link |
| Mathematical | Group Sum | Link |
| Library | Date Time | Link |
| Date Time | Date | Link |
| Date Time | Time | Link |
| Date Time | Time Now | Link |
| Date Time | Report Time To Seconds | Link |
| Date Time | Seconds To Report Time | Link |
| Date Time | Time | Link |
| Date Time | Time To Seconds | Link |
| Date Time | ZULU | Link |
| Date Time | Day Between | Link |
| Date Time | Month To number | Link |
| Library | Data | Link |
| Data | Deletion | Link |
| Data | Remove Duplicate Records | Link |
| Data | Flag Duplicate Records | Link |
| Library | Conversion | Link |
| Conversion | Convert Data field | Link |
| Conversion | Convert Form Id | Link |
| Conversion | Convert Client Id | Link |
| Library | Cross Form | Link |
| Cross Form | Copy To Destination | Link |
| Cross Form | Cross Form Update | Link |
| Cross Form | Cross Form Insert | Link |
| Cross Form | Cross Form Update Simple/Custom | Link |
| Cross Form | Cross Form Update Smart | Link |
| Library | CCL Specific | Link |
| CCL Specific | Insert Into CCL Simple | Link |
| CCL Specific | Insert From CCL Custom | Link |
| Library | QA | Link |
| QA | Cross Database QA Fail All Check | Link |