This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello, so i have a situation where I need to replace values in a table. Here is my example.
I have a table with the following data:
The ids' 311 and 312 are leftover from a legacy system. However, we do have a table with the new and old legacy systems id's
I need to automatically search the ID field in the first table to identify the old system id's (312, 311) and replace them with the corresponding Id's in the new system, iN this CASE, replace 312 and 311 with ID'S 03 and 04. IF no equivalent id's are found, then the cell should remain empty. I know I need to do a join but not sure what to do without having to do a manual search and replace.