2556782 - Incorrect Export Results due to Filter in Data Workbench

Upon checking the Work center view for any object Z (for example Accounts, Opportunities etc.) via Advanced search, using any filter criteria, there are a total of X records. Your requirement is to export those X records using Data Workbench. Upon exporting the records using Data Workbench, you see Y records.

Example:

We are exporting the Prospects based on the Countries PQR or XYZ.

In Data Workbench workcenter, upon setting the Filter as below, the results are calculated as Y records.
Country – Equals To – PQR
Country – Equals To – XYZ
Role – Equals To - Prospect

You want to understand how to handle the same attributes (Country in my example) in Data Workbench, using the correct filters.

*Z represents the Object in Data Workbench
X represents the total records available in the workcenter view for the Object
Y represents the total records calculated for export in Data Workbench
PQR and XYZ represents the Countries

SAP Cloud for Customer

Filter in Data Workbench, Selection Criteria in Data Workbench, Filter Condition, Account , KBA , selection criteria in data workbench , filter in data workbench , LOD-CRM-INT-DWB , Data Workbench , Problem