Join Condition

This topic describes how to extract data from multiple tables using a single Process file. You can add a new table to the existing table joins without recording the entire process again.

The Join Condition option is available only for Data Extractor technology and is displayed in the Settings section only if the Process file contains at least two tables.

Process Runner supports custom data extraction using an extended remote function module (RFM) that extends the Data Extractor technology allowing you to extract data from different tables or views. To create a join between tables for custom data extraction, configure the Data Extractor settings in the Tools > Options > Data Extractor tab and select Use Extended RFM. For more information, see Data Extractor.

To add a new table and create joins

  1. Open the Data Extractor Process file that you want to update, select Home tab > Tables in the Settings section. The Tables (<TableNames>) window is displayed.
  2. On the Tables tab, select Add. The Add Table window is displayed. Perform the following steps:
    1. Enter the table name in Table Name. If you are entering multiple tables, separate the table names with a comma. For example, LTAK,LTBK.
    2. To automatically map all SAP fields to Excel columns, select Automap all fields.
    3. To retrieve the field descriptions from SAP in your logon language, select Get Descriptions.
    4. Select OK. The Magnitude Connector for SAP window is displayed. Perform the following steps:
      1. Select the SAP system, select Logon, and enter the information for Client, User, Password, and Language.
      2. Select OK. The table is added to the list and Process Runner automatically creates joins between the tables based on the primary keys under the Join Condition tab.
    5. Optionally, on the Join Condition tab, edit the default join condition and select OK.
  3. Save the Process file and select Run. The Excel file is displayed with the data from the three tables, LTAP, LTAK and LTBK.

    4. For information about how to extract data from three tables using the dynamic table join condition functionality, see Extract Data From Three SAP Tables Using Dynamic Table Join Feature.