How to compate two fileds having only charecters and linking

[#1]

Dear Friends,

Kindly help me to solve below issue.

I Have Table 'A'  in that one column named 'Location'.

I have one more Table 'B' having 'Location' Column and 'Branch Address' Column.

For each Location in Table 'B' there is corresponding 2 to 3 Branch address.

Location column in Table 'A' is having same branch details of Table'B' Location but with some additional data.

Now i need to match Location in Table'A' and Table'B' and need to show Corresponding branch details.

So kindly help me how to match Locations which are in charecters in two different tables and to link Them.

Note : PFA for Reference

Warm Regards,

Vinay N

[sunny_talwar]

Can you share some underlying data to see what those two columns include?? Without looking at the data within those columns, it would be very hard to give any suggestions.

Best,

Sunny

[giakoum]

you need to make the 2 columns match otherwise there will be no link.

Ways to do that is by using either ApplyMap or a link table.

Depends on your data what is the best solution

[#4]

Hi Sunindia,

Please refer the Attachment for your reference. Thanks for the updaate

[daniel_kusiak]

See the attached file.

For each "Branch Address" in Table B there have to be  a Location.

[giakoum]

see attached. i changed your excel file to make sense