Table Tool
Table Tool
One Tool Example
Table has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.
Use Table to create a data or pivot table to output in a report via the Render tool.
Table Headers and Footers
To include a header or footer in your table, add a Report Text tool directly below the Table tool and select Attach Text to Existing Field.
Configure the Tool
Table Tool Column Order
If the number of fields/columns that feed into the Table tool varies, you might notice that in certain cases, the tool outputs columns in an order that is different than you expect.
When you run a workflow and subsequently select the Table tool on the canvas, the tool configuration uses the fields that just ran through it, since the tool reconfigures itself when you select it.
At this point, if you add any other fields, they are placed at the end of your dataset because these are considered Dynamic or Unknown Fields and are configured to go at the end. If after you include these fields, you click off the Table tool and select it again, the tool once again reconfigures itself (this time with the full list of fields/columns in the order that you specified). As a result, the Table tool outputs these additional fields in the right order.
Keep this in mind if your Table tool configuration uses dynamically populated fields/columns.
Table Mode and Group By Selection
Table Mode: Select a type of table. Options are:
Basic
Pivot (Cross Tab): Use the Pivot mode when you use data from a Cross Tab tool.
Group By: Select the fields to group by. A separate table is created for each group of records.
Table Configuration
Table Width: Select the width of the table.
Automatic: Sets the minimum width for the data contained within a table to display.
Percentage: Sets the percentage of the page for the table to be displayed, where 100% is the entire width of the page.
Fixed: Sets the width of the table in inches.
Pivot Style (use with Cross Tab tool): Select the style for displaying the data in the table. This option is only available when you use data from a Cross Tab tool. Refer to the Data Examples section below to learn more. Compare the beginning data example to the example output for each Pivot Style option.
Bar Graph (use with Basic table mode): Specify the data field for which to create a bar graph in the table. This option is only available for a basic table. Select Settings to modify the style of the bar graph.
Show Column Headings: Displays column headings in the table. This option cannot be deselected for a pivot table.
Per Column/Methodology Configuration
Per Column/Methodology Configuration: If the table mode is Basic, configure the columns and if the table mode is Pivot, configure the methodologies.
Select the data fields to include in the table.
Select a data field and use the up and down arrows to change the order in which the data displays in the table.
Select a data field to configure these attributes:
Rename Field: Enter a new name for the data field.
Width: Select Automatic, Percentage, or Fixed for the width of the data within a column.
Alignment (H): Select the horizontal alignment of left, center, or right.
Borders: Select to have borders on the left or right sides, or both sides, or to not have any borders.
Prefix: Enter text to add before the data.
Suffix: Enter text to add after the data.
Dec. Places: Select the number of decimal places to include.
Column Rules: Create or edit a rule to apply to a column of data. For style options, visit Table Style Rules.
Table Style Settings
Default Table Settings: Modify style options for the table. For style options, go to Table Settings Style Editor.
Create/Edit Row Rule: Create or edit a rule to apply to a column of data. For style options, visit Table Style Rules.
Table Tool in Apps and Macros
Because this tool includes an expression editor, an additional input anchor displays when you use the tool in an app or macro workflow. Use the Interface tools to connect to a Question anchor.
Pivot (Cross Tab) Data Examples
Compare the Beginning Data Example to the example outputs that follow.
Beginning Data Example
LocaleDesc | Avg_Regular | XRow_Regular | XCol_Regular | Count_Regular | Avg_Special_Ed | XRow_Special_Ed | XCol_Special_Ed | Count_Special_Ed | Avg_Voc_Tech_Other | XRow_Voc_Tech_Other | XCol_Voc_Tech_Other | Count_Voc_Tech_Other | Total |
Central City | 57 | 97 | 15 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 8 | 1 | 59 |
Rural | 182 | 97 | 49 | 1 | 0 | 0 | 0 | 0 | 6 | 3 | 23 | 1 | 188 |
Town | 116 | 87 | 31 | 1 | 1 | 1 | 50 | 1 | 16 | 12 | 62 | 1 | 133 |
Unknown | 5 | 63 | 1 | 1 | 1 | 13 | 50 | 1 | 2 | 25 | 8 | 1 | 8 |
Urban Fringe | 9 | 100 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 |
Total | 74 | 93 | 100 | 5 | 1 | 1 | 100 | 2 | 7 | 7 | 100 | 4 | 397 |
Methodology over Variable
Methodology over Variable: The method for aggregating the data displays above the selected data field.
Avg | XRow | XCol | |||||||||||
LocaleDesc | TotCol | Regular | Special Ed | Voc/Tech/Other | Regular | Special Ed | Voc/Tech/Other | Regular | Special Ed | Voc/Tech/Other | Regular | Special Ed | Voc/Tech/Other |
Central City | 59 | 57 | 0 | 2 | 97 | 0 | 3 | 15 | 0 | 8 | 1 | 0 | 1 |
Rural | 188 | 182 | 0 | 6 | 97 | 0 | 3 | 49 | 0 | 23 | 1 | 0 | 1 |
Town | 133 | 116 | 1 | 16 | 87 | 1 | 12 | 31 | 50 | 62 | 1 | 1 | 1 |
Unknown | 8 | 5 | 1 | 2 | 63 | 13 | 25 | 1 | 50 | 8 | 1 | 1 | 1 |
Urban Fringe | 9 | 9 | 0 | 0 | 100 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 |
Total | 397 | 74 | 1 | 7 | 93 | 1 | 7 | 100 | 100 | 100 | 5 | 2 | 4 |
Variable over Methodology
Variable over Methodology: The selected data field displays above the method for aggregating the data.
Regular | Special Ed | Voc/Tech/Other | |||||||||||
LocaleDesc | TotCol | Avg | XRow | XCol | Count | Avg | XRow | XCol | Count | Avg | XRow | XCol | Count |
Central City | 59 | 57 | 97 | 15 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 8 | 1 |
Rural | 188 | 182 | 97 | 49 | 1 | 0 | 0 | 0 | 0 | 6 | 3 | 23 | 1 |
Town | 133 | 116 | 87 | 31 | 1 | 1 | 1 | 50 | 1 | 16 | 12 | 62 | 1 |
Unknown | 8 | 5 | 63 | 1 | 1 | 1 | 13 | 50 | 1 | 2 | 25 | 8 | 1 |
Urban Fringe | 9 | 9 | 100 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total | 397 | 74 | 93 | 100 | 5 | 1 | 1 | 100 | 2 | 7 | 7 | 100 | 4 |
Pivot Methodology to the Left
Pivot Methodology to the Left: The method for aggregating the data displays on the left side for each row of data in the table.
LocaleDesc | TotCol | Regular | Special Ed | Voc/Tech/Other | |||||||||
Central City | 59 | Avg | 57 | 0 | 2 | Central City | 59 | Avg | 57 | 0 | 2 | Central City | 59 |
XRow | 97 | 0 | 3 | XRow | 97 | 0 | 3 | ||||||
XCol | 15 | 0 | 8 | XCol | 15 | 0 | 8 | ||||||
Count | 1 | 0 | 1 | Count | 1 | 0 | 1 | ||||||
Rural | 188 | Avg | 182 | 0 | 6 | Rural | 188 | Avg | 182 | 0 | 6 | Rural | 188 |
XRow | 97 | 0 | 3 | XRow | 97 | 0 | 3 | ||||||
XCol | 49 | 0 | 23 | XCol | 49 | 0 | 23 |
Pivot Variable to the Left
Pivot Variable to the Left: The data displays in the table on the left side of the method for aggregating the data.
LocaleDesc | TotCol | Avg | XRow | XCol | |||||||||
Central City | 59 | Regular | 57 | 97 | 15 | 1 | Central City | 59 | Regular | 57 | 97 | 15 | 1 |
Special Ed | 0 | 0 | 0 | 0 | Special Ed | 0 | 0 | 0 | 0 | ||||
Voc/Tech/Other | 2 | 3 | 8 | 1 | Voc/Tech/Other | 2 | 3 | 8 | 1 | ||||
Rural | 188 | Regular | 182 | 97 | 49 | 1 | Rural | 188 | Regular | 182 | 97 | 49 | 1 |
Special Ed | 0 | 0 | 0 | 0 | Special Ed | 0 | 0 | 0 | 0 | ||||
Voc/Tech/Other | 6 | 3 | 23 | 1 | Voc/Tech/Other | 6 | 3 | 23 | 1 | ||||
Town | 133 | Regular | 116 | 87 | 31 | 1 | Town | 133 | Regular | 116 | 87 | 31 | 1 |