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 | ||
|- | |- | ||
| − | | Library || String || [[MetaData_-_Processing_Rules_-_String_Management|Link]] | + | | style="color:green; background-color:#ffffcc;" | Library || String || [[MetaData_-_Processing_Rules_-_String_Management|Link|Link]] |
|- | |- | ||
| − | | String || Append || [[MetaData_-_Processing_Rules_-_String_Management#Append]] | + | | String || Append || [[MetaData_-_Processing_Rules_-_String_Management#Append|Link]] |
|- | |- | ||
| − | | String || Prepend || [[MetaData_-_Processing_Rules_-_String_Management#Prepend]] | + | | String || Prepend || [[MetaData_-_Processing_Rules_-_String_Management#Prepend|Link]] |
|- | |- | ||
| − | | String || Encapsulate || [[MetaData_-_Processing_Rules_-_String_Management#Encapsulate]] | + | | String || Encapsulate || [[MetaData_-_Processing_Rules_-_String_Management#Encapsulate|Link]] |
|- | |- | ||
| − | | String || Remove Numbers || [[MetaData_-_Processing_Rules_-_String_Management#Remove_Numbers]] | + | | String || Remove Numbers || [[MetaData_-_Processing_Rules_-_String_Management#Remove_Numbers|Link]] |
|- | |- | ||
| − | | String || Strip Tags || [[MetaData_-_Processing_Rules_-_String_Management#Strip_Tags]] | + | | String || Strip Tags || [[MetaData_-_Processing_Rules_-_String_Management#Strip_Tags|Link]] |
|- | |- | ||
| − | | String || Replace || [[MetaData_-_Processing_Rules_-_String_Management#Replace]] | + | | String || Replace || [[MetaData_-_Processing_Rules_-_String_Management#Replace|Link]] |
|- | |- | ||
| − | | String || Concatenation || [[MetaData_-_Processing_Rules_-_String_Management#Concatenation]] | + | | String || Concatenation || [[MetaData_-_Processing_Rules_-_String_Management#Concatenation|Link]] |
|- | |- | ||
| − | | String || Read From || [[MetaData_-_Processing_Rules_-_String_Management#Read_From]] | + | | String || Read From || [[MetaData_-_Processing_Rules_-_String_Management#Read_From|Link]] |
|- | |- | ||
| − | | String || Read Until || [[MetaData_-_Processing_Rules_-_String_Management#Read_Until]] | + | | String || Read Until || [[MetaData_-_Processing_Rules_-_String_Management#Read_Until|Link]] |
|- | |- | ||
| − | | String || Set Value || [[MetaData_-_Processing_Rules_-_String_Management#Set_Value]] | + | | String || Set Value || [[MetaData_-_Processing_Rules_-_String_Management#Set_Value|Link]] |
|- | |- | ||
|} | |} | ||
| Line 39: | Line 39: | ||
! Link | ! Link | ||
|- | |- | ||
| − | | Library || Mathematical || [[MetaData_-_Processing_Rules_-_Mathematical_Functions]] | + | | Library || Mathematical || [[MetaData_-_Processing_Rules_-_Mathematical_Functions|Link]] |
|- | |- | ||
| − | | Mathematical || Addition || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Addition]] | + | | Mathematical || Addition || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Addition|Link]] |
|- | |- | ||
| − | | Mathematical || Subtraction || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Subtraction]] | + | | Mathematical || Subtraction || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Subtraction|Link]] |
|- | |- | ||
| − | | Mathematical || Multiplication || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Multiplication]] | + | | Mathematical || Multiplication || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Multiplication|Link]] |
|- | |- | ||
| − | | Mathematical || Division || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Division]] | + | | Mathematical || Division || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Division|Link]] |
|- | |- | ||
| − | | Mathematical || Modulus || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Modulus]] | + | | Mathematical || Modulus || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Modulus|Link]] |
|- | |- | ||
| − | | Mathematical || Numeric || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Numeric]] | + | | Mathematical || Numeric || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Numeric|Link]] |
|- | |- | ||
| − | | Mathematical || Summation || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Summation]] | + | | Mathematical || Summation || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Summation|Link]] |
|- | |- | ||
| − | | Mathematical || Count || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Count]] | + | | Mathematical || Count || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Count|Link]] |
|- | |- | ||
| − | | Mathematical || Is Unique || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Is_Unique]] | + | | Mathematical || Is Unique || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Is_Unique|Link]] |
|- | |- | ||
| − | | Mathematical || Group Count || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Count]] | + | | Mathematical || Group Count || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Count|Link]] |
|- | |- | ||
| − | | Mathematical || Group Sum || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Sum]] | + | | Mathematical || Group Sum || [[MetaData_-_Processing_Rules_-_Mathematical_Functions#Group_Sum|Link]] |
|- | |- | ||
|} | |} | ||
| Line 70: | Line 70: | ||
! Link | ! Link | ||
|- | |- | ||
| − | | Library || Date Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management]] | + | | Library || Date Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management|Link]] |
|- | |- | ||
| − | | Date Time || Date || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date]] | + | | Date Time || Date || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date|Link]] |
|- | |- | ||
| − | | Date Time || Date|Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date.7CTime]] | + | | Date Time || Date|Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date.7CTime|Link]] |
|- | |- | ||
| − | | Date Time || Date|Time Now || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date.7CTime_Now]] | + | | Date Time || Date|Time Now || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Date.7CTime_Now|Link]] |
|- | |- | ||
| − | | Date Time || Report Time To Seconds || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Report_Time_To_Seconds]] | + | | Date Time || Report Time To Seconds || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Report_Time_To_Seconds|Link]] |
|- | |- | ||
| − | | Date Time || Seconds To Report Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Seconds_To_Report_Time]] | + | | Date Time || Seconds To Report Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Seconds_To_Report_Time|Link]] |
|- | |- | ||
| − | | Date Time || Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Time]] | + | | Date Time || Time || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Time|Link]] |
|- | |- | ||
| − | | Date Time || Time To Seconds || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Time_To_Seconds]] | + | | Date Time || Time To Seconds || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Time_To_Seconds|Link]] |
|- | |- | ||
| − | | Date Time || ZULU || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#ZULU]] | + | | Date Time || ZULU || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#ZULU|Link]] |
|- | |- | ||
| − | | Date Time || Day Between || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Day_Between]] | + | | Date Time || Day Between || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Day_Between|Link]] |
|- | |- | ||
| − | | Date Time || Month To number || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Month_To_number]] | + | | Date Time || Month To number || [[MetaData_-_Processing_Rules_-_Date_and_Time_Management#Month_To_number|Link]] |
|- | |- | ||
|} | |} | ||
| Line 99: | Line 99: | ||
! Link | ! Link | ||
|- | |- | ||
| − | | Library || Data || [[MetaData_-_Processing_Rules_-_Data_Management]] | + | | Library || Data || [[MetaData_-_Processing_Rules_-_Data_Management|Link]] |
|- | |- | ||
| − | | Data || Deletion || [[MetaData_-_Processing_Rules_-_Data_Management#Deletion]] | + | | Data || Deletion || [[MetaData_-_Processing_Rules_-_Data_Management#Deletion|Link]] |
|- | |- | ||
| − | | Data || Remove Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Remove_Duplicate_Records]] | + | | Data || Remove Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Remove_Duplicate_Records|Link]] |
|- | |- | ||
| − | | Data || Flag Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Flag_Duplicate_Records]] | + | | Data || Flag Duplicate Records || [[MetaData_-_Processing_Rules_-_Data_Management#Flag_Duplicate_Records|Link]] |
|- | |- | ||
|} | |} | ||
| Line 114: | Line 114: | ||
! Link | ! Link | ||
|- | |- | ||
| − | | Library || Conversion || [[MetaData_-_Processing_Rules_-_Data_Conversion]] | + | | Library || Conversion || [[MetaData_-_Processing_Rules_-_Data_Conversion|Link]] |
|- | |- | ||
| − | | Conversion || Convert Data field || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Data_field]] | + | | Conversion || Convert Data field || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Data_field|Link]] |
|- | |- | ||
| − | | Conversion || Convert Form Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Form_Id]] | + | | Conversion || Convert Form Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Form_Id|Link]] |
|- | |- | ||
| − | | Conversion || Convert Client Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Client_Id]] | + | | Conversion || Convert Client Id || [[MetaData_-_Processing_Rules_-_Data_Conversion#Convert_Client_Id|Link]] |
|- | |- | ||
|} | |} | ||
| Line 129: | Line 129: | ||
! Link | ! Link | ||
|- | |- | ||
| − | | Library || Cross Form || [[MetaData_-_Processing_Rules_-_Cross_Form]] | + | | Library || Cross Form || [[MetaData_-_Processing_Rules_-_Cross_Form|Link]] |
|- | |- | ||
| − | | Cross Form || Copy To Destination || [[MetaData_-_Processing_Rules_-_Cross_Form#Copy_To_Destination]] | + | | Cross Form || Copy To Destination || [[MetaData_-_Processing_Rules_-_Cross_Form#Copy_To_Destination|Link]] |
|- | |- | ||
| − | | Cross Form || Cross Form Update || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update]] | + | | Cross Form || Cross Form Update || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update|Link]] |
|- | |- | ||
| − | | Cross Form || Cross Form Insert || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Insert]] | + | | Cross Form || Cross Form Insert || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Insert|Link]] |
|- | |- | ||
| − | | Cross Form || Cross Form Update Simple/Custom || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Simple.2FCustom]] | + | | Cross Form || Cross Form Update Simple/Custom || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Simple.2FCustom|Link]] |
|- | |- | ||
| − | | Cross Form || Cross Form Update Smart || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Smart]] | + | | Cross Form || Cross Form Update Smart || [[MetaData_-_Processing_Rules_-_Cross_Form#Cross_Form_Update_Smart|Link]] |
|- | |- | ||
|} | |} | ||
| Line 148: | Line 148: | ||
! Link | ! Link | ||
|- | |- | ||
| − | | Library || CCL Specific || [[MetaData_-_Processing_Rules_-_CCL_Specific]] | + | | Library || CCL Specific || [[MetaData_-_Processing_Rules_-_CCL_Specific|Link]] |
|- | |- | ||
| − | | CCL Specific || Insert Into CCL Simple || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_Into_CCL_Simple]] | + | | CCL Specific || Insert Into CCL Simple || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_Into_CCL_Simple|Link]] |
|- | |- | ||
| − | | CCL Specific || Insert From CCL Custom || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_From_CCL_Custom]] | + | | CCL Specific || Insert From CCL Custom || [[MetaData_-_Processing_Rules_-_CCL_Specific#Insert_From_CCL_Custom|Link]] |
|- | |- | ||
|} | |} | ||
| Line 161: | Line 161: | ||
! Link | ! Link | ||
|- | |- | ||
| − | | Library || QA || [[MetaData_-_Processing_Rules_-_QA_Specific]] | + | | 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 | ||
| Line 168: | Line 168: | ||
| − | [[Category:Module Specific:MetaData]] | + | [[Category:Module Specific:MetaData|Link]] |
Revision as of 23:10, 7 February 2017
Contents
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|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 |
1.2 Mathematical Functions
| Type | Function | 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 |
1.3 Date Time Functions
| Type | Function | 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 |
1.4 Data Functions
| Type | Function | Link |
|---|---|---|
| Library | Data | Link |
| Data | Deletion | Link |
| Data | Remove Duplicate Records | Link |
| Data | Flag Duplicate Records | Link |
1.5 Conversion Functions
| Type | Function | Link |
|---|---|---|
| Library | Conversion | Link |
| Conversion | Convert Data field | Link |
| Conversion | Convert Form Id | Link |
| Conversion | Convert Client Id | Link |
1.6 Cross Form Functions
| Type | Function | 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 |
1.7 CCL Specific Functions
| Type | Function | Link |
|---|---|---|
| Library | CCL Specific | Link |
| CCL Specific | Insert Into CCL Simple | Link |
| CCL Specific | Insert From CCL Custom | Link |
1.8 QA Specific Functions
| Type | Function | Link |
|---|---|---|
| Library | QA | Link |
| QA | Cross Database QA Fail All Check | [[MetaData_-_Processing_Rules_-_QA_Specific#Cross_Database_QA_Fail_All_Check |