Orange polygon with white table with multiple rows.

Table Tool

Version:
Current
Last modified: October 21, 2019

The Table tool creates a data or pivot table to output in a report via the Render tool.

Table headers and footers

To include a header or footer to your table, add a Report Text Tool directly below the Table tool and select Attach Text to Existing Field.

Configure the tool

Table Mode: Select a type of table. Options are: Basic or Pivot (Cross Tab). Use the Pivot mode when using 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 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: Select the style for displaying the data in the table. This option is only available when using data from a Cross Tab tool. Compare the beginning data example to the example output for each option.

Data examples

Compare the Beginning data example to the example outputs in the tabs 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 data field selected.

    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 data field selected 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

Bar Graph: Specify the data field to create a bar graph for in the table. This option is only available for a basic table. Click 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: If the table mode is Basic, configure the columns and if the table mode is Pivot, then configure the methodologies.

  • Select the data fields to include in the table.
  • Click a data field and use the up and down arrows to change the order the data displays in the table.
  • Click a data field to configure the following attributes:
  • Rename Field: Type 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: Type text to add before the data.
  • Suffix: Type 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, see Table Style Rules.

 

Default Table Settings: Modify style options for the table. For style options, see Table Settings Style Editor.

Create/Edit Row Rule: Create or edit a rule to apply to a column of data. For style options, see Table Style Rules.

Because this tool includes an expression editor, an additional input anchor displays when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor. See Interface Tools.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.