on 08-10-201602:47 PM - edited on 07-27-202111:37 PM by APIUserOpsDM
This 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 Michael 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
Output to your Database Connections
Create Alias connections which allows you to update your database password in all workflows where thatAlias exists
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
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 output 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 filename as a field. De-select to keep your output data the same as the end of your workflow
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 firstname.lastname@example.org you’d like your creative tool uses to be featured in the Tool Mastery Series.
Stay tuned with our latest posts every Tool Tuesdayby following Alteryxon Twitter! If you want to master all the Designer tools, consider subscribingfor email notifications.