Hello everyone,
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)
SiteTable:
- Site Name
- Site Code
- RootPath
UserTable
- UserName
- UserPath
And I want to merge it in a new table with the following information:
- UserName
- SiteName
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.