ImportDataTable Script Examples

This page contains script examples for the ImportDataTable script command.

This example loads 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