Please also have a look in our OnlineHelp for further information.
We can use the component XtractIS Report to use reports as a data source. But sometimes reports contain groups and headers or any other disturbing rows between the relevant rows (e.g. delimiters or column names in the middle of the report). This Article shows how you can eliminate the rows which are containing no relevant data, and how to insert information from the group header to referred columns and rows.
The following example extracts data from the Report RFITEMAP. The report RFITEMAP - Vendor Line Item Display - groups the Report to the single Vendor. The Report is called with the Transaction FBL1N.
After we have put the component into the Data Flow task and we double click it, we get into the Editor. We assign a Variant to get the Data assessable.
To continue, please preview the report at least once by clicking the “Preview” button. Use the report column editor at the bottom and the table on the upper right to define new columns. A column is defined by its name, offset and length. The following screenshot shows how the report should look like when it is properly defined.
The next step is to insert a script component into the Data Flow. With a double click on the component we get into the Script Transformation Editor. We add a column with the name “ Vendor” under the screen Inputs and Outputs. We also change the value of the Exclusion Group to 1 if it’s 0 at the Common Properties of the Output Pipeline.
In the lower part of the Script Screen is the Button “Design Script…”. Click on it and we get into the Visual Basic Editor. Now we insert the following rows.
Now we get only the filtered rows with the respective vendor number in the Vendor column.