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.
here is the use case: I have to tables (let's name as table 1 and table 2). In table 1, there is a column named item with many strings, for example "TRIVITRON HEALTHCARE PRIVATE Hitachi LIMITED". Table two is a brand table with only one column named brand (for example "Hitachi"). What I wanna do is to find out brand in my item column in table 1.
for example, if you can find "Hitachi"(or some other brands name in table 2), then return ''Hitachi" in a new column in table 1; if not, leave it as blank.
the problem for me is there are too many brands need to compare, so I need a loop to figure it out.
Looking forward to any possible solutions you guys offer to me and thanks so much