Render tool – this allows Alteryx to output the objects in many different forms, either temporarily or permanently.Layout tool – this lets Alteryx move and reorder the configuration of multiple tables (which is exactly what we have).Table – this will allow Alteryx to turn the data into a table object (This should only be carried out after any data preparation has occurred as it will now be treated by Alteryx in the same vein any reporting object would be (only viewable via a browse tool)).To do the output via 1 tool we will need to bring in and use 3 tools from the reporting tool set: Using the above method would work, but you would now receive 3 separate files instead, and would hence require 3 output tools. So imagine you are that regional manager and you want it broken down into the overall sales, like you are receiving above, an aggregation by client (Customer), and also a breakdown by product category. However, what if we wanted to send multiple different reports? So in this example, it is outputting all the sales for our store across Europe, but splitting each page by country so they can go to the relevant regional managers. However, this has its limitations, only allowing us to output the same sheet, but grouping it by a different field. Now anyone who is experienced with Alteryx may know that you can use the default output tool to output identical sheets, by using the “Take File/Table Name From Field” and “Changing the File/Table Name”. Often when using Alteryx, or in any form of reporting, we can find ourselves wanting to output different data sections or different findings into multiple places. If you would like to follow along with this exersice or view an example please follow this link | Samuel Shurmer Writing Multiple Tables to 1 (or Multiple) Sheets in Excel with Alteryx
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |