HI ,
I have two sources, one contains records along with state, the second source is a lookup file which contains all the information along with states, districts, so and so.
What I need to do is from the source I have to take state column and match up with the lookup state column and get the districts which are in that state alone for that particular record and then use find and replace it with that address column to get that corresponding districts.
The Source File:
The Lookup File:
For each records I have to do it in a looping manner and take that respective districts alone for consideration and then find and replace for that group alone for each records.
P.S: I cannot use all the districts for find and replace because it affects the integrity of the data and I tried unique in lookup and find and replace but that doesn't work too!
