Use Single SELECT SQL for Multiple Fields

The Use single SELECT SQL for multiple fields option allows you to use recordset returning multiple fields from sql query in data filter where clause in data extractor. This facilitates to map different fields in where clause to a single recordset instead of writing sql query for each fields.

To use Single Select SQL,

1. Select filter condition as Data Filter Builder from Home Tab.

   

2. Select Use Single SELECT SQL for multiple fields check-box. The SELECT SQL window where you need to enter SELECT statement for creating recordset appears.

   

3. Enter the select statement as per your requirement and select OK. To know more about building single row at a time, see Build single row at a time.
4. To make any changes in SELECT statement, select SELECT SQL Query.
5. To use the fields from resulting recordset, select the source type DS To SAP and select source value from the drop down that will display all the fields from the recordset.

   

   

6. Similarly map other fields in the where condition and execute your process file.