|
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 Skip that are offered:
1.Skip Excel row on Blank 2.Skip Excel row on Zero 3.Skip Excel row on Blank or Zero or Space(s) 4.Suppress field on Blank 5.Suppress field on Zero 6.Suppress field on Blank or Zero or Space(s) 7.Skip Current Call on Blank 8.Skip Current Call on Zero 9.Skip Current Call On Blank or Zero or Space(s) 10.Data Governance Rule 11.Custom Dynamic Skip
In the below example, we will extract 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.
1.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). 
2.Click on Home tab 3.Check the 'Use Data Filters' checkbox and choose 'Data Filter Builder' option. 
4.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). 5.Similarly choose 'ERNAM' , Source Type as Excel to SAP, Source Value as 'B'(column consisting Name of the Person Who Changed Object in excel). 
6.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 button and then click on Run button in 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.
➢CALL: Execution of one complete recording of the mapper.
Types of 'Return Values' are as following:
Return Values
|
Description
|
Return 0
|
It is default return value. It will execute the field normally
|
Return 1
|
It will suppress the field and will not send the field to SAP
|
Return 2
|
Scenario A: Single line call
|
It will skip the row and hence the call will be skipped. (Refer screen 1 and 3)
|
Scenario B: Multi line call
|
It will skip the row (single line) in loop. (Refer screen 4 and 6)
|
|
Return 3
|
Scenario A: Single line call
|
It will skip the current call. (Refer screen 2 and 3)
|
Scenario B: Multi line call
|
It will skip the entire call (whole loop). (Refer screen 5 and 6)
|
|
Return 4
|
Stop current SAP execution which is similar to pressing 'Stop' button in Process Runner.
|
 Screen-1 |
 Screen-2 |
 Screen-3
 Screen-4 |
 Screen-5 |
 Screen-6 |
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. Please note that 'Validate Data Governance Rule' option is not available for Data Extractor.
To know more about Data Governance and how this work, please refer to Data Governance Overview and Data Governance in Process Runner.
|
Next:
Dynamic Formula - Introduction
| 
