Yesterday we saw the basics how to create a project with the Business Rules Maintenance Web Application and connect the resulting Zip file to a Pentaho PDI transformation. Enter a name and description for the rule. Next enter the exact name of the field (here: "Field_002" - the name of the field from the PDI transformation) and select the data type of the field. Next select which check you want to use (here: CheckIsEqual to check for equality). Next enter the value to check against (here: "large_airport") and select the data type. Next enter a message in case the rule fails and one in case it passes. Placeholders can be used - $0 is the value to check against you entered before ("large_airport") and $1 is the actual value from the CSV file in the transformation. Click on save and then go back. Go back to Pentaho PDI. Right-click the last step to get a preview of the data. The data will come from the CSV file, run through the rule engine and all rows that pass the rulegroup we defined (consisting of the two rules: airport type = large_airport AND state= US-NY) will go to the step labeled "Passed Rows". You can now easily add more rules - additional logic - without cluttering the transformation! You will have noticed that after writing the rules, we did not touch the transformation anymore. That is because the logic is external to the transformation.
0 Comments
Leave a Reply. |
AuthorUwe Geercken Categories
All
Archives
September 2020
|