Pivot for database tables: There can be different used cases where the user needs to pivot the data. In the example below, Sales and Profit is grouped by Year and Country

Using this tool, users can select the required fields and measures for which they would like to do aggregation. In the example below Discount, Profit, Quantity, and Sales is grouped by Year of Sales, Region and City.Īlteryx, also provides a direct tool named as “Summarize”, which performs all types of aggregation. A user can add a step to aggregate the data and simply drag and drop the required field for aggregation. Tableau prep provides an option to do a quick aggregation of data to store in the data source or tableau data extract (tde). In Alteryx, “Browse” tool is used to preview the data. This feature provides the easy way to validate the data after the transformation stepĪlteryx, also provides the option to preview and validate the data after performing any type of transformation. This can be very useful feature for evaluating join conditions and validating data.įeatures that are common to both “Tableau Prep” and “Alteryx”ĭata preview: In Tableau Prep, after performing the data transformation step, the user can use the “Preview in Tableau Desktop” option to look at the data in tableau desktop.

In tableau prep, a user gets “Summary of Join Results” option that shows unmatched values.

When we do join or union in Tableau, the result is shown in the bottom Data Source tabīut, often it happens that the user wants to see that based on the join conditions what data is joined or what didn’t. Join and Union: As we all know, Tableau Desktop provides the ability to the user to join or union multiple data sources directly. Objective: In this article to do a comparison between Tableau Prep and Alteryx, I am going to mention the features of both Tableau Prep and Alteryx in the following ways:ġ.)A feature that is present only Tableau Prep but not in Alteryxģ.)A feature that is available in Alteryx but not in Tableau Prep A feature that is present only Tableau Prep but not in Alteryx

Tableau prep workflow