âShow Table of Contents
The Cross Tab tool pivots the orientation of data in a table by moving vertical data fields onto a horizontal axis and summarizing data where specified. The Cross Tab tool is the reverse application of the Transpose tool which pivots the orientation of the data from horizontal to vertical. There is no limit to the amount of records or fields that can be passed through the Cross Tab tool.
Beginning with Alteryx 10.5, if two or more cells contain the same string with different capitalization, an error will be produced at runtime. (In previous versions, identical strings with differing capitalization were used to create separate columns with modified names.) To resolve this, ensure that the data in each cell is unique or that the capitalization is consistent for matching data.
Select a Method for Aggregating Values for combining multiple values in a field. Available options depend on the data type of the value selected in the Values for New Columns field.
Options for String data include:
Options for Number data include:
When choosing one or more of the methods above, an abbreviation for that method will be prepended to the column header, unless SUM, First, or Last is the only method selected. Examples: AVG_FieldValue, SUM_FieldValue, COUNT_FieldValue.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.