Hi,
I have a bunch of records which have similarities in the description field of the source file and I need to consolidate all such records and add a separate ID to all such records in a different field. Example data is like this.
1 Rajani Kumar
2 Roman Rytov
3 Rytov Roman
4 Rytov R
5 Kumar Rajani
Here,1&5 represent the same Record for Rajani Kumar
and 2,3 & 4 represent same record for Roman Rytov.
So, I need to give an Id into a different destination field - A for Rajani Kumar(that is for 1&5 records)and B for Roman Rytov (that is for 2,3 &4 records).
Any solutions for this scenario while importing the records using Import Manager? Which is the best method ??
Regards,
RK