Dynamic Skip in Data Extractor
Dynamic Skips or DS allows you to skip elements at run time based on criteria you specify. Frequently used criteria are already provided. You can also define your own skip criteria using Custom DS. Custom DS is written in VB.NET code and similar to Macro that you write inside Excel/Word.
Dynamic Skip can be set for field in Data Extractor. Following are the Dynamic Skips that are offered:
- Skip Excel row on Blank
- Skip Excel row on Zero
- Skip Excel row on Blank or Zero or Space(s)
- Suppress field on Blank
- Suppress field on Zero
- Suppress field on Blank or Zero or Space(s)
- Skip Current Call on Blank
- Skip Current Call on Zero
- Skip Current Call On Blank or Zero or Space(s)
- Data Governance Rule
- Custom Dynamic Skip
In the following example, we skip the data from MARA table and see how dynamic skip can be used to skip data based on the specified criteria. Once the data consisting of 'Material Number' and 'Name of Person who Created the Object' is ready in excel file for which data is to be extracted, go to Mapper tab and follow the steps mentioned below:
- In the Mapper, uncheck the 'Active' checkbox for the fields for which data is to be filtered (i.e taken from excel file mentioned above).
- Click on Home tab
- Check the 'Use Data Filters' checkbox and choose 'Data Filter Builder' option.
- In the Data Filter Builder window, choose 'MATNR' in Field Name, Source Type as Excel to SAP and Source Value as 'A' (column consisting material number in excel).
- Similarly choose 'ERNAM' , Source Type as Excel to SAP, Source Value as 'B'(column consisting Name of the Person Who Changed Object in excel).
- Choose Dynamic skips offered under Dynamic Skip column for the required field.
In our example we will choose 'Name of Person who Created the Object' field and use dynamic skip options (skip excel row/suppress field/skip current call/custom DS) if value of this field is either 0 or blank as covered in below sections.
One can perform “Skip Excel Row on Zero”, “Skip Excel Row on Blank” or “Skip Excel Row on Blank or Zero or Space(s)” to skip the row in which value of ERNAM (Name of Person who Created the Object) field is either 0 or blank.
Click OK and then click Run in the toolbar.
After successful run, one can clearly see the excel log column displaying “Row Skipped due to DS”.
One can perform “Suppress field on Zero”, “Suppress field on Blank” or “Suppress field on Blank or Zero” to suppress selected fields.
Call to SAP can be skipped using “Skip Current Call on Blank”, “Skip Current Call on Zero” or “Skip Current Call on Blank or Zero or Space(s)”.
Click OK button and then click on Run button in toolbar.
On successful Run, message “Call to SAP skipped due to custom DS ” is displayed.
Custom DS allows users to write their VB.Net code to perform various run-time actions based on the data they put in their excel data sheet.
Click on Run in the toolbar.
Note: If the return value is:
- 0 - It will continue to work.
- 1 - Suppress or do not send the field to SAP
- 2 - Skip current Excel row
- 3 - Skip current Call
- 4 - Stop current SAP execution
Lets consider 'Material Number' field present in the excel file and use 'MARA' SAP table to download material information for the material number that exist in table/view else display the error as designed in the rule of Innowera Control Panel.
Choose Y- Data Governance Rule option for Material Number and select the rule that will validate the data for the selected field.
Execute the process. Note that 'Validate Data Governance Rule' option is not available for Data Extractor.
For information about Data Governance, see Data Governance Rule.