How to configure a Batch Splitting step to split on a blank value
Version: R76
Article ID: PC000070
Description
Summary
The following steps should be used to configure batch splitting using a blank value. Note: These steps assume you will be splitting the batch based on an index field called “ExampleIndexField”. The index field should already exist in the job.
To split the batch on a blank value using the String Comparison type:
- Setup the Target Job Configuration.
- Add a batch split step.
- Add a New Condition.
- The condition source: Capture Index
- Choose Capture Index: “ExampleIndexField”
- Choose Comparison Type: String Comparison
- Leave the drop down on the equal sign “=” and leave the text box, blank.
- Click Finish
- The condition should read (CI.ExampleIndexField = “”)
To split the batch on a blank value using the Regular Expression Comparison type:
- Setup the Target Job Configuration.
- Add a batch split step.
- Add a New Condition
- The condition source: Capture Index
- Choose Capture Index: “ExampleIndexField”
- Choose Comparison Type: Regular Expression
- Input the Regular Expression which represents any blank space characters: ^\s*$
- Click Finish
- The condition should read (CI.ExampleIndexField RegEx.Match(“^\s*$”)