Difference between revisions of "MetaData Process Rules"

From All n One's bxp software Wixi

Jump to: navigation, search
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