ImportDataTable Script Examples: Difference between revisions
Jump to navigation
Jump to search
(403051) |
No edit summary |
||
| Line 1: | Line 1: | ||
This page contains script examples for the [[ | This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23ImportDataTable|ImportDataTable]] script command. | ||
The following example will load data from a model and put it into the "AnalysisResult" table and then add that data to the "ExampleTable" data table. | The following example will load data from a model and put it into the "AnalysisResult" table and then add that data to the "ExampleTable" data table. | ||
Revision as of 07:42, 7 February 2018
This page contains script examples for the ImportDataTable script command.
The following example will load data from a model and put it into the "AnalysisResult" table and then add that data to the "ExampleTable" data table.
SELECT 'START' --#WriteLog (SELECT 'AnalysisType', '6') UNION ALL (SELECT 'MaximumCount', '0') UNION ALL (SELECT 'FilterId', '3') UNION ALL (SELECT 'SelectedEventAttributes', '*') UNION ALL (SELECT 'TargetTable', '#AnalysisResult') --#GetAnalysis SELECT 'DataLoaded' --#WriteLog SELECT count(*) from [#AnalysisResult] --#WriteLog (SELECT 'ProjectId', '1') UNION ALL (SELECT 'DataTableName', 'ExampleTable') UNION ALL (SELECT 'Append', '1') (SELECT * FROM [#AnalysisResult]) --#ImportDataTable
The following example will load data from the "ExampleTable" data table in the "ExampleProject" project, put that data into the "CSV1" table and then show the contents of the "CSV" table. In effect, it shows the contents of the "ExampleTable" data table.
(SELECT 'AnalysisType', '18') UNION ALL (SELECT 'ProjectName', 'ExampleProject') UNION ALL (SELECT 'MaximumCount', '0') UNION ALL (SELECT 'DataTableName', 'ExampleTable') UNION ALL (SELECT 'TargetTable', '#CSV1') --#GetAnalysis (SELECT * FROM #CSV1) (SELECT 'Title', 'CSV Table') UNION ALL (SELECT 'MaximumCount', '0') --#ShowReport