Import maps for qualified table
I have multiple vendor records in excel file for same vendor.
during process of importing i want to import only one vendor for all duplicates but all values of qualified fields of duplicate records to be imported.
ex: V1 Qualified field A1
V1 Qualified field A2
V1 Qualified field A3
import map should import the records as V1 A1
Where V1 is the main table and A1, A2, A3 are Qualified table values.
Please check the below steps:
1. Open the excel file in Import Manager
2. Map the Vendor field with the main table field
3. Map the non-qualifier field with the Qualified field present in the main table
4. Map the Qualifiers.
When you perform Record Matching it will show create 3 records but after importing when you check it will create only one record and 3 qualified records.