Difference between revisions of "Pentaho:Cleanser:Input Fields"
Jump to navigation
Jump to search
(Created page with "{{PentahoCleanserNav |CleanserTabsCollapse= }} {{CustomTOC}} link= Category:Pentaho Category:Pentaho Cleanser") |
|||
Line 7: | Line 7: | ||
[[File:PENT_Cleanser_InputFields.png|link=]] | [[File:PENT_Cleanser_InputFields.png|link=]] | ||
==Cleanser Input== | |||
Here you have a list of input fields and what operations will be performed on them. | |||
;Save Operation | |||
:Click this button to save the operation. | |||
;Remove Saved Operation | |||
:Click this button to remove the saved operation. | |||
==Cleanser Operation== | |||
;Input Field | |||
:Name of the input field. | |||
;Operation Name | |||
:Name of the operation. | |||
;Operation Description | |||
:Description of the operation. | |||
==Rule Settings== | |||
;Add Rule | |||
:Click this button to add a rule to the designated input field. This rule will be based off of the settings you set below. | |||
;Remove Rule | |||
:Click this button to remove the selected rule for the designated input field. | |||
;Cleanser Rule | |||
:Selects the cleanser rule type. | |||
;Field Data Type | |||
:Designates the expected data type in the field. | |||
;Rule Option | |||
:Selects the rule option for the field. | |||
===Triggers=== | |||
;Use Trigger Expression | |||
:Check this option to use trigger expressions. | |||
;Expression | |||
:Select this option to enable the use of expressions. You may use the [[Pentaho:Cleanser:Expression Builder|Expression Builder]] to build complex expressions. | |||
;Regular Expression | |||
:Select this option to enable the use of regular expressions. | |||
===Search and Replace Options=== | |||
;Use Search Term | |||
:Select this option to use a search term. | |||
:;Search | |||
::The value to search for. | |||
:;Replace | |||
::The value to replace the search term. | |||
;Use Table | |||
:Select this option to use a table. | |||
:;Table Path | |||
::The path for the table. | |||
[[Category:Pentaho]] | [[Category:Pentaho]] | ||
[[Category:Pentaho Cleanser]] | [[Category:Pentaho Cleanser]] |
Latest revision as of 23:30, 16 September 2016
← Data Quality Components for Pentaho
Cleanser Navigation | |||
---|---|---|---|
Overview | |||
Tutorial | |||
Advanced Configuration | |||
| |||
Expression Builder | |||
Result Codes |
Cleanser Input
Here you have a list of input fields and what operations will be performed on them.
- Save Operation
- Click this button to save the operation.
- Remove Saved Operation
- Click this button to remove the saved operation.
Cleanser Operation
- Input Field
- Name of the input field.
- Operation Name
- Name of the operation.
- Operation Description
- Description of the operation.
Rule Settings
- Add Rule
- Click this button to add a rule to the designated input field. This rule will be based off of the settings you set below.
- Remove Rule
- Click this button to remove the selected rule for the designated input field.
- Cleanser Rule
- Selects the cleanser rule type.
- Field Data Type
- Designates the expected data type in the field.
- Rule Option
- Selects the rule option for the field.
Triggers
- Use Trigger Expression
- Check this option to use trigger expressions.
- Expression
- Select this option to enable the use of expressions. You may use the Expression Builder to build complex expressions.
- Regular Expression
- Select this option to enable the use of regular expressions.
Search and Replace Options
- Use Search Term
- Select this option to use a search term.
- Search
- The value to search for.
- Replace
- The value to replace the search term.
- Use Table
- Select this option to use a table.
- Table Path
- The path for the table.