If you look at attached images, there are two XML files left and right mapped automatically by system with some logic.
But if you see closely creation date and date of birth are getting mapped with the same field i.e. src_dateofbirth because system check and match "date" text and put some extra logic, but in this case it is incorrect and need user intervention.
Most of the time there will be 80+ fields both side and mapping and correction manually is messy and unfriendly.
So I have concluded few solutions and would like community to help.
What I will do
- Map the fields automatically
- If multiple fields from left table are getting mapped with a single entity of right table. Show some visual clue. [current system doesn't provide this feature]
- If there is some fields not mapped, highlight[current system doesn't provide this feature]
- What else?