How can we apply a filter when loading balance to reconciliation compliance

Summary:

We are trying to filter out some of the data in the csv file and load the rest of the data as the balance for a account in Reconciliation compliance.

Content (required):

Hi there,

The client wants to match the balance of GL/ERP with their own system. The data for their own system is in csv format, I am able to create the integration with the source = file and target = ARM

The file includes more information than we want. There is a column in the file that we can use for filter and we only need certain types of data. We want to IGNORE all those we dont want using map members like this.