One can perform “Skip on Zero”, “Skip on Blank” or “Skip on Blank or Zero”. For our convenience, we will take “Skip on Blank or Zero” to cover both the cases.
Refer the screens below, we will skip the row in which amount is either 0 or blank.
For this, go to Mapper & in the Dynamic Skip column for the field Amount select “C-Skip Excel on Blank or Zero”.
Click on Run button.
After successful Run, one can clearly see the excel log column displaying “Row skipped due to DS”.
Next:
Suppress Field on Blank or Zero | Suppress Screen on Blank or Zero | Custom DS on Field