Profiler Object:Append Mode - Revision history

Admin at 21:17, 19 December 2016

2016-12-19T21:17:03Z

← Older revision		Revision as of 21:17, 19 December 2016
Line 24:		Line 24:
	</pre>		</pre>

	'''5. Call the SetLicenseString function to set the ~~license string~~. This was supplied by your Melissa Data Representative.'''		'''5. Call the SetLicenseString function to set the License Key. This was supplied by your Melissa Data Representative.'''
	<pre>		<pre>
	CALL SetLicenseString WITH LicenseString		CALL SetLicenseString WITH LicenseString

Admin at 00:29, 3 March 2015

2015-03-03T00:29:11Z

← Older revision		Revision as of 00:29, 3 March 2015
Line 19:		Line 19:
	</pre>		</pre>

	'''4. ~~SetAppend~~ Mode to Append.'''		'''4. Set Append Mode to Append.'''
	<pre>		<pre>
	CALL SetAppendMode WITH AppendModeAppend		CALL SetAppendMode WITH AppendModeAppend

Admin at 00:24, 3 March 2015

2015-03-03T00:24:43Z

← Older revision		Revision as of 00:24, 3 March 2015
Line 2:		Line 2:

	You can open an existing profiling file for Append without any change to the order of operation code except for the SetAppendMode that needs to be set AppendModeAppend. The Profiler will ignore any column specifications or rules (example: SetColumnCustomPattern, SetColumnValueRange, SetColumnDefaultValue, SetColumnSize, SetColumnPrecision or SetColumnScale). The following pseudo-code shows the order of operation with only the necessary code to open the Profiler file in Append Mode.		You can open an existing profiling file for Append without any change to the order of operation code except for the SetAppendMode that needs to be set AppendModeAppend. The Profiler will ignore any column specifications or rules (example: SetColumnCustomPattern, SetColumnValueRange, SetColumnDefaultValue, SetColumnSize, SetColumnPrecision or SetColumnScale). The following pseudo-code shows the order of operation with only the necessary code to open the Profiler file in Append Mode.


	'''1. Create an instance of the Profiler object.'''		'''1. Create an instance of the Profiler object.'''

Admin at 00:24, 3 March 2015

2015-03-03T00:24:34Z

← Older revision		Revision as of 00:24, 3 March 2015
Line 1:		Line 1:
	{{ProfilerIntroductionNav}}		{{ProfilerIntroductionNav}}


	~~{{CustomTOC}}~~

	You can open an existing profiling file for Append without any change to the order of operation code except for the SetAppendMode that needs to be set AppendModeAppend. The Profiler will ignore any column specifications or rules (example: SetColumnCustomPattern, SetColumnValueRange, SetColumnDefaultValue, SetColumnSize, SetColumnPrecision or SetColumnScale). The following pseudo-code shows the order of operation with only the necessary code to open the Profiler file in Append Mode.		You can open an existing profiling file for Append without any change to the order of operation code except for the SetAppendMode that needs to be set AppendModeAppend. The Profiler will ignore any column specifications or rules (example: SetColumnCustomPattern, SetColumnValueRange, SetColumnDefaultValue, SetColumnSize, SetColumnPrecision or SetColumnScale). The following pseudo-code shows the order of operation with only the necessary code to open the Profiler file in Append Mode.

Admin at 00:24, 3 March 2015

2015-03-03T00:24:18Z

← Older revision		Revision as of 00:24, 3 March 2015
Line 32:		Line 32:

	'''6. Configure the profiler object by setting these functions. These are not mandatory.'''		'''6. Configure the profiler object by setting these functions. These are not mandatory.'''
	</pre>		<pre>
	CALL SetSortAnalysis WITH SortAnalysisValue		CALL SetSortAnalysis WITH SortAnalysisValue
	CALL SetMatchUpAnalysis WITH MatchUpAnalysisValue		CALL SetMatchUpAnalysis WITH MatchUpAnalysisValue

Admin: Created page with "{{ProfilerIntroductionNav}} {{CustomTOC}} You can open an existing profiling file for Append without any change to the order of operation code except for the SetAppendMode ..."

2015-03-03T00:23:46Z

Created page with "{{ProfilerIntroductionNav}} {{CustomTOC}} You can open an existing profiling file for Append without any change to the order of operation code except for the SetAppendMode ..."

New page

{{ProfilerIntroductionNav}}

{{CustomTOC}}

You can open an existing profiling file for Append without any change to the order of operation code except for the SetAppendMode that needs to be set AppendModeAppend. The Profiler will ignore any column specifications or rules (example: SetColumnCustomPattern, SetColumnValueRange, SetColumnDefaultValue, SetColumnSize, SetColumnPrecision or SetColumnScale). The following pseudo-code shows the order of operation with only the necessary code to open the Profiler file in Append Mode.

'''1. Create an instance of the Profiler object.'''
<pre>
Create profiler as New Instance of mdProfiler
</pre>

'''2. Set path to the profiler data files.'''
<pre>
CALL SetPathToProfilerDataFiles WITH DataPath
</pre>

'''3. Call the SetFilename function to set the Profiler file you want to open on Append Mode.'''
<pre>
CALL SetFileName WITH ExistingFile
</pre>

'''4. SetAppend Mode to Append.'''
<pre>
CALL SetAppendMode WITH AppendModeAppend
</pre>

'''5. Call the SetLicenseString function to set the license string. This was supplied by your Melissa Data Representative.'''
<pre>
CALL SetLicenseString WITH LicenseString
</pre>

'''6. Configure the profiler object by setting these functions. These are not mandatory.'''
</pre>
CALL SetSortAnalysis WITH SortAnalysisValue
CALL SetMatchUpAnalysis WITH MatchUpAnalysisValue
CALL SetRightFielderAnalysis WITH RightfielderAnalysisValue
CALL SetDataAggregation WITH DataAggregationValue
</pre>

'''7. Call the InitilializeDataFiles function to connect the Profiler Object to its supporting data file.'''
<pre>
CALL InitializeDataFiles RETURNING Result
IF Result IS 0 THEN
CALL GetBuildNumber Returning BuildNumber
CALL GetDatabaseDate Returning DBExpireDate
CALL GetLicenseExpirationDate Returning LicenseExpireDate
ELSE
CALL GetInitializeErrorString Returing ErrorString
Print ErrorString
END IF
</pre>

'''8. Initiate profiling by calling StartProfiling function.'''
<pre>
CALL StartProfiling
</pre>

'''9. Loop through the input data file lines and set the column values.'''
<pre>
WHILE ReadingInputLines
FOREACH Column column in InputLine
CALL SetColumn WITH column.Name, column.Value
CALL AddRecord RETURNING ResultCodesString
CALL GetResults WITH column.Name RETURNING ResultCodes
END LOOP
</pre>

'''10. CALL ProfileData function to do profiling for data aggregations.'''
<pre>
CALL ProfileData
</pre>

'''11. CALL the list of required functions to get the profiled values. These functions have been categorized into three different sections: table, column, and iterator get functions.'''

For example:
<pre>
CALL GetColumnMostPopularCount WITH ColumnName RETURNING Int
CALL GetTableRecordCount RETURNING Int
</pre>

[[Category:Profiler Object]]