Difference between revisions of "MetaData Process Rules"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| Line 10: | Line 10: | ||
! style="width:25%" | Link | ! style="width:25%" | Link | ||
|- | |- | ||
| − | | style="color:green; background-color:#ffffcc;" | Library || String || [[MetaData_-_Processing_Rules_-_String_Management | + | | style="color:green; background-color:#ffffcc;" | Library || String || [[MetaData_-_Processing_Rules_-_String_Management|Link]] |
|- | |- | ||
| String || Append || [[MetaData_-_Processing_Rules_-_String_Management#Append|Link]] | | String || Append || [[MetaData_-_Processing_Rules_-_String_Management#Append|Link]] | ||
| Line 32: | Line 32: | ||
| 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]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | Library || Mathematical || [[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 63: | Line 56: | ||
| 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]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | Library || Date Time || [[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 92: | Line 78: | ||
| 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]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | Library || Data || [[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 107: | Line 86: | ||
| 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]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | Library || Conversion || [[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 122: | Line 94: | ||
| 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]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | Library || Cross Form || [[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 141: | Line 106: | ||
| 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]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | Library || CCL Specific || [[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 154: | Line 112: | ||
| 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]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | Library || QA || [[MetaData_-_Processing_Rules_-_QA_Specific|Link]] | ||
|- | |- | ||
| QA || Cross Database QA Fail All Check || [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check | | QA || Cross Database QA Fail All Check || [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check | ||
Revision as of 23:12, 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 | [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check |