Output Data Tool
Use Output Data to write results of a workflow to supported file types or data sources.
Select the Output Data tool in the palette, and drag it onto the workflow canvas.
Tool Components
 |
Figure: Output Data tool with anchor.
The Output Data tool has 1 anchor.
Input anchor: Connect the output anchor to your workflow to write your workflow results to a data source or supported file type.
Configure the Tool
Download File
To download the results of your workflow, select Download File:
Enter a File Name.
Select your File Format:
Comma Separated Values (.csv)
Microsoft Excel 1997 - 2003 (.xls)
Microsoft Excel (.xlsx)
If you select a CSV file format, select a Delimiter.
Choose options for your output:
Include Quotes (CSV file format only)
Sheet Name (XLS and XLSX formats only)
Include Column Names as First Row
Select Save to save your download details.
Save and run your workflow. The output file appears in the Recent Job section of the tool configuration window.
Select the output file, then select Download Output File.
Save to Connections
To write the results of your workflow to a data source:
Select a connection from Connections.
Select your Table Options:
Create New: Creates a new table. Enter a new Table Name.
Override Existing Table: Replaces an existing table with the one from your workflow.
From the list, select the schema to save your table to, then select Continue.
Your Table Path shows where your table will be written.
Select your Output Actions on Every Run:
Create New
Append
Truncate
Drop
Merge
Select Save.
Save and run your workflow. The output file appears in the Recent Job section of the tool configuration window.
Your table is saved to your chosen connection.