Pentaho:Profiler:Input Fields - Revision history

Admin at 18:55, 19 October 2015

2015-10-19T18:55:58Z

← Older revision		Revision as of 18:55, 19 October 2015
Line 45:		Line 45:
	Double-clicking select fields or the "..." button to the right of the rows will bring up the Advanced Settings dialogue. Check the box next to any option to enable it's modification. These settings allow for validating your data. Records that do not meet the specified validation rules in the Advanced Options will be given a result code indicating failure.		Double-clicking select fields or the "..." button to the right of the rows will bring up the Advanced Settings dialogue. Check the box next to any option to enable it's modification. These settings allow for validating your data. Records that do not meet the specified validation rules in the Advanced Options will be given a result code indicating failure.

	[[file:~~PENT_Profiler_AdvancedSetting~~.png\|link=]]		[[file:PENT_Profiler_AdvancedSettings.png\|link=]]

	;Scale		;Scale
Line 68:		Line 68:
	Checking the box next to Regular Expressions and then selecting the "Add..." button will bring up the Regular Expression Builder.		Checking the box next to Regular Expressions and then selecting the "Add..." button will bring up the Regular Expression Builder.

	[[file:~~PENT_Profiler_RegularExpression~~.png\|link=]]		[[file:PENT_Profiler_RegularExpressions.png\|link=]]


	[[Category:Pentaho]]		[[Category:Pentaho]]
	[[Category:Pentaho Profiler]]		[[Category:Pentaho Profiler]]

Admin: Admin moved page Pentaho:Profiler:Input Field to Pentaho:Profiler:Input Fields

2015-10-19T18:55:34Z

Admin moved page Pentaho:Profiler:Input Field to Pentaho:Profiler:Input Fields

← Older revision	Revision as of 18:55, 19 October 2015
(No difference)

Admin at 15:58, 19 October 2015

2015-10-19T15:58:56Z

← Older revision		Revision as of 15:58, 19 October 2015
Line 8:		Line 8:
	The input field tab maps the input columns to be profiled. Each column can be passed through and/or column-specific results can be output. Not all columns are required.		The input field tab maps the input columns to be profiled. Each column can be passed through and/or column-specific results can be output. Not all columns are required.

	[[file:~~PENT_Profiler_InputField~~.png\|link=]]		[[file:PENT_Profiler_InputFields.png\|link=]]

	Advanced profiling options can be modified for any field by clicking the "..." button to the right of any row. See [[#Advanced Settings\|Advanced Settings]] for more information.		Advanced profiling options can be modified for any field by clicking the "..." button to the right of any row. See [[#Advanced Settings\|Advanced Settings]] for more information.

Admin at 15:47, 19 October 2015

2015-10-19T15:47:52Z

← Older revision		Revision as of 15:47, 19 October 2015
Line 8:		Line 8:
	The input field tab maps the input columns to be profiled. Each column can be passed through and/or column-specific results can be output. Not all columns are required.		The input field tab maps the input columns to be profiled. Each column can be passed through and/or column-specific results can be output. Not all columns are required.

	[[file:~~Pentaho_PF_InputField~~.png\|link=]]		[[file:PENT_Profiler_InputField.png\|link=]]

	Advanced profiling options can be modified for any field by clicking the "..." button to the right of any row. See [[#Advanced Settings\|Advanced Settings]] for more information.		Advanced profiling options can be modified for any field by clicking the "..." button to the right of any row. See [[#Advanced Settings\|Advanced Settings]] for more information.
Line 45:		Line 45:
	Double-clicking select fields or the "..." button to the right of the rows will bring up the Advanced Settings dialogue. Check the box next to any option to enable it's modification. These settings allow for validating your data. Records that do not meet the specified validation rules in the Advanced Options will be given a result code indicating failure.		Double-clicking select fields or the "..." button to the right of the rows will bring up the Advanced Settings dialogue. Check the box next to any option to enable it's modification. These settings allow for validating your data. Records that do not meet the specified validation rules in the Advanced Options will be given a result code indicating failure.

	[[file:~~Pentaho_PF_AdvancedSetting~~.png\|link=]]		[[file:PENT_Profiler_AdvancedSetting.png\|link=]]

	;Scale		;Scale
Line 68:		Line 68:
	Checking the box next to Regular Expressions and then selecting the "Add..." button will bring up the Regular Expression Builder.		Checking the box next to Regular Expressions and then selecting the "Add..." button will bring up the Regular Expression Builder.

	[[file:~~Pentaho_PF_RegularExpression~~.png\|link=]]		[[file:PENT_Profiler_RegularExpression.png\|link=]]


	[[Category:Pentaho]]		[[Category:Pentaho]]
	[[Category:Pentaho Profiler]]		[[Category:Pentaho Profiler]]

Admin: Created page with "{{ PentahoProfilerNav |ProfilerTabsCollapse= }} {{CustomTOC}} The input field tab maps the input columns to be profiled. Each column can be passed through and/or column-spe..."

2015-09-15T19:36:04Z

Created page with "{{ PentahoProfilerNav |ProfilerTabsCollapse= }} {{CustomTOC}} The input field tab maps the input columns to be profiled. Each column can be passed through and/or column-spe..."

New page

{{ PentahoProfilerNav
|ProfilerTabsCollapse=
}}

{{CustomTOC}}

The input field tab maps the input columns to be profiled. Each column can be passed through and/or column-specific results can be output. Not all columns are required.

[[file:Pentaho_PF_InputField.png|link=]]

Advanced profiling options can be modified for any field by clicking the "..." button to the right of any row. See [[#Advanced Settings|Advanced Settings]] for more information.

;Profile
:Designates the selected field to be profiled.

;PassThrough
:Designate the selected field as a pass-through column. The data will be passed through to the output.

;Results
:Designates the selected field

;Column Name
:The name of the column from the source file.

;Expected Contents
:Use the drop-down menu to select the expected contents of the input column.

;Data Type
:Displays the data type of the column.

;Length
:Displays the maximum length of the column. Double-clicking this field will bring up the [[#Advanced Settings|Advanced Settings]] dialogue where you can changed this value.

;Precision
:Displays the precision of the column. Double-clicking this field will bring up the [[#Advanced Settings|Advanced Settings]] dialogue where you can changed this value.

;Scale
:Displays the scale of the column. Double-clicking this field will bring up the [[#Advanced Settings|Advanced Settings]] dialogue where you can changed this value.

;Settings
:Displays any special settings for the column. Double-clicking this field will bring up the [[#Advanced Settings|Advanced Settings]] dialogue where you can changed this value.

==Advanced Settings==
Double-clicking select fields or the "..." button to the right of the rows will bring up the Advanced Settings dialogue. Check the box next to any option to enable it's modification. These settings allow for validating your data. Records that do not meet the specified validation rules in the Advanced Options will be given a result code indicating failure.

[[file:Pentaho_PF_AdvancedSetting.png|link=]]

;Scale
:Set the scale of the column.

;Precision
:Set the precision of the column.

;Max Length
:Set the maximum length of the column.

;Default Value
:Set the default value.

;Upper & Lower Bounds
:Set the Upper and Lower bounds values.

;Regular Expressions
:Set a list of regular expressions. See [[#Regular Expression Builder|Regular Expression Builder]] for more information.

===Regular Expression Builder===
Checking the box next to Regular Expressions and then selecting the "Add..." button will bring up the Regular Expression Builder.

[[file:Pentaho_PF_RegularExpression.png|link=]]

[[Category:Pentaho]]
[[Category:Pentaho Profiler]]