Data Extractor

Data Extractor

Simple View of Master Grid in Data Extractor Technology

 

The following table will describe the significance of each field for the simple view of Data Extractor technology

 

Module

Option

Description

Headers

Parameter Name

This check box tells Process Runner to either consider the given row or not. Setting a row to inactive (de-selecting) will instruct Process Runner to keep the row but not to look at when you execute this process


Field

Displays SAP Field name


Field Description

Displays Field or Screen description if you had earlier requested that information while creating this file. This is purely for information or readability purpose and does not impact how Data Extractor file is executed.


Mapping Type

Displays the Mapping type of the row as to what behavior it belongs to among the following

 

Sub-Option

Description

Excel to SAP

Instructs the Process Runner to get the value from Excel column

SAP to Excel

Instructs the Process Runner to place value received from SAP to given Excel column

Fix Single Value

Instructs the Process Runner to use value provided in "Map Value" column

System Value

Instructs the Process Runner to use dynamically calculated value as provided in "Map Value" column

Excel Cell Value

Instructs the Process Runner to place value received from SAP to given Excel cell

 


Map Value

In this field you provide actual mapped value based on Mapping Type. For example, if you have mapping type set as "Excel to SAP", you specified which Excel column to use in this column


Filters

Option-wise

Each header field consist an option-filter that is visible only if the mouse is hovered on the header. Click on that filter icon and select the option from the displayed list to filter the grid with selected option.


Custom-filter

Each column consist an text field below the header field. Type the text in that field to filter the master grid with typed text.

Selection Area

The selection area is stationed at the left-most column of the master grid. Sometimes user may require to select multiple rows simultaneously, in such cases user can click and drag the mouse pointer to select the rows as shown in the image below.

 

Click here to expandSwitch the view of Mapper tab's 'Master Grid' to Simple view
Click here to expandShow/Hide Excel Data at Simple View of Master Grid
Click here to expandShow/Hide Excel Toolbar for Excel Data  
Click here to expandView only Active Rows
Click here to expandView Only Inactive Rows
Click here to expandView All Rows (Active and Inactive both)  

 

Next

Advanced View