The following section gives a general introduction to working with Xtract for Alteryx using the 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 also SAP Connection).
  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.

Adding an SAP Table #

Tip: Wildcard such as * are supported.

  1. Within the window “Table” click [Add] to add a table.
    Add-New-Table
    The window “Table Lookup” opens.
    Look-Up-Table
  2. In the field Table name (1) enter the name of the table to extract.
  3. Click [Search] (magnifying glass) (2). Search results appear in the preview window.
  4. Select the desired table (3) and click [OK] (4).

The application returns to the main window of the component.

Columns of the table retrieved from SAP are displayed in the subsection Fields.
Table-Form

Number Element
1 Field selection, filtering
2 Filter fields
3 Conversion Routine
4 Preview window, result of the conversion

Filtering tables #

You can select either all or only individual columns for extraction. Per default all columns are automatically selected for table extraction. Deselect the ones you don’t wish to extract.
Click the header fields to sort the columns by name or description.
To search for a certain column name or description, start typing the word in the filter boxes.

Table-Main

Using live preview #

  1. Click [Load live preview] to load 100 records for preview.
  2. Click [OK] to confirm and save the extraction in the repository, i.e. on the server.

Table-Main