community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Tool Mastery | Output Data

Alteryx
Alteryx
Created on

Output Data.pngThis article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Output Data Tool on our way to mastering the Alteryx Designer:

 

Once you have started a workflow within Alteryx it's hard to think about leaving! However, if you feel like that time has come, Alteryx makes that transition easier than Micheal Phelps winning Gold in the Olympics. The Output Data Tool is used to write the results of your workflow to any supported database or file formats; Alteryx also offers the opportunity to output directly to Tableau Server, and Power BI. Using the Output Data Tool, you can:

 
  • Output to your Local and Network Drives 

Pic 1.png

 

  • Output to your Database Connections

Pic 2.png

 

 

  • Create Alias connections which allows you to update your database password in all workflows where that Alias exists

Pic 3.png

 

  • Once you have chosen your output format you will have the opportunity to adjust the Options section. Within here you can choose the output method you want, number of records to output and a field map to name a few

pic 4.png

 

  • And.......as if those output formats were not  enough! The Output Tool has the option of outputting multiple files at once based on a certain field within your dataset! For example, you have run your whole analysis for every region within your database. You now want to output those records to different sheets within the same Excel file, or output them to completely different files all together. You can tick the 'Take File/Table Name from Field' and adjust the drop down menu to output to different files or sheets. For any file format other than Excel you can use the 'Change File/Table Name' to output to different files. For Excel, this same option will output to different sheets, however if you want to out to different Excel files you will need to add a formula tool and use 'Change Entire File Path' option in the dropdown menu. 'Keep Field in Output' will keep the file name as a field. De-select to keep your output data the same as the end of your workflow

 

Pic 5.png

 

See the attached workflow, as well as the hyperlinks above (different sheetsdifferent Excel files), for working examples. Workflows built in Alteryx Designer 10.6. 

 

By now, you should have expert-level proficiency with the Output Data Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know at community@alteryx.com if you’d like your creative tool uses to be featured in the Tool Mastery Series.

 

Stay tuned with our latest posts every Tool Tuesday by following Alteryx on Twitter! If you want to master all the Designer tools, consider subscribing for email notifications.

Attachments