Orange polygon with white table with multiple rows.

Ferramenta Tabela

Versão:
2023.1
Last modified: March 09, 2023

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 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 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 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
Esta página foi útil?

Problemas com seu produto Alteryx? Visite a Comunidade Alteryx ou entre em contato com nossa Equipe de Suporte. Não é possível enviar este formulário? Envie-nos um e-mail.