You can use the Filter Source Rows option to filter and manually map source rows to the target business entities or relationships. For example, the source file contains a CreditCard source row and you need to map this row to the correct target business entity. Drag and drop the CreditCard source row to the Filter Source Rows panel. A list of target business entities display with Credit Card as one of the options. You can map the CreditCard source row to the Credit Card target business entity.
In the
New File Import
panel, under
Map Fields
, click the filter icon.
The
Filter Source Rows
box appears.
From the source columns, drag and drop a source row to the
Filter Source Rows
box.
The source row appears in the Filter Source Rows box.
In the text box, enter a filter condition and click
Apply
.
The target business entities appear based on the filter conditions you enter.