Sorry if my question was already asked to the community, but I didn’t find the response on this forum.
I have 2 table with the following data (both imported from an excel file)
- Site Name
- Site Code
And I want to merge it in a new table with the following information:
The join between both should be done by the RootPath and the UserPath.
But the data are not formated exactly the same way.
I need to check if the UserPath end with the Site path.
I’m pretty sure this is easy to do, but i can’t figure out how to proceed.
Thanks in advance for your support.