The following section gives a general introduction to working with Xtract for Alteryx using the Xtract Table component as an example. The information described in the following section is a prerequisite for all subsequent sections.

Note: An SAP Connection is a requirement for using any of Xtract for Alteryx components.

Creating an Extraction #

  1. Drag the Xtract Table (1) component to the canvas to create a new table extraction. The “Configuration” window opens. Create-New-Table-Extraction
  2. Under subsection Connection, select an existing SAP connection (2) or create a new one (3). See SAP Connection for more information.
  3. Under subsection Selected Extraction click [Edit] to configure a new table extraction. Create-New-Table-Extraction2
  4. The main window of the component opens. In this window you can define simple table extractions or join tables for extractions. In the following example, a single table is extracted.

Look up a Table #

  1. In the main window of the component click [Add] to add a table. The window “Table Lookup” opens.
    table_main-window_add
  2. In the window “Table Lookup” enter the name of the table to extract (1). Use wildcards (*) if needed.
    Look-Up-Table
  3. Click [Search] ( magnifying-glass icon) (2). Search results appear in the preview window.
  4. Select a table (3) and click [OK] (4).

All relevant metadata information of the table is retrieved from SAP. The application now returns to the main window of the component.

Set Up a Table Extraction #

Set up the Table component to extract SAP tables:

  1. Select the columns you want to extract. By default all columns are selected. Deselect the columns you do not want to extract.
    Table-Form
  2. Optional: Define a WHERE clause or a HAVING clause to filter table records. By default all data is extracted.
  3. Click [Load live preview] to display a live preview of the first 100 records.
  4. Click [OK] to save the extraction.

You can now run the extraction.

Table-Main