Skip Rows in Reports

This articles shows how to skip certain rows when extracting SAP reports.
The depicted example uses the Row Skip Pattern option of the Report extraction type to remove rows that contain the * symbol in extracted reports.

About Row Skip Patterns

The extraction settings of the Report extraction type include the Row Skip Pattern option. Row Skip Pattern allows you to define a pattern that removes all rows that contain the pattern from the extracted report. This can be used to remove header rows that are repeated in the output body of reports.

• Regular expressions are supported
• Multiple row skip patterns can be entered, separated by the pipe symbol "|", e.g., 2020|2021|-|Sum removes all rows containing ‘2020’, ‘2021’, ‘-‘ and ‘Sum’.
• To process special symbols, add \before the symbol, e.g., \* removes rows that contain the sum symbol * .
• Only works with database destinations, e.g., Azure Storage, Snowflake, SQl Server, etc.

How to Use Row Skip Patterns

In the depicted example, the report RFITEMGL contains rows that total the content of the rows before. These rows are marked with an * symbol:

To remove all rows that contain the * symbol, follow the instructions below:

1. Look up a report. The depicted example uses the report RFITEMGL.
2. Define the columns of the report automatically or manually, see Documentation: Define the Report Extraction Type.
   
3. Click Extraction Settings. The window "Extraction Settings" open.
   
4. Enter a Row skip pattern. To process special symbols, add \before the symbol, e.g., to remove rows that contain the sum symbol * , enter \*.
5. Click [OK] to close the extraction settings.
6. Click [OK] to save the extraction. Note that the live preview of the report component does not include the Row skip pattern option. Row skip pattern is only executed when running the extraction.
7. Run the extraction.

The extracted report does not include rows that contain a * symbol.