Hi folks,
I am trying to add a ProductName filed in Table1. Then I will join Table1 with Table2 on ProductName.
In Table1, I have a ProductDescription column. The first several letters of each ProductDescription indicates the ProductName. Eg. The ProductName of “Pandacookielover” is “Panda”. The ProductName of “Tomatorocks” is “Tomato”.
Could you guys give me some idea how I can handle this issue please?
Thanks a lot!!
Jaylynn
In table1
I have a “ProductDescription” field as follows.
Table1
ProductDescripton | Colum1 | Colum2 | Colum3 | Colum4 | Colum5 |
Pandacookielover | | | | | |
Pandacleaningmodel | | | | | |
Tigerneverlaugh | | | | | |
Tigerlaughtoomuch | | | | | |
Tomatorocks | | | | | |
Tomatoclubmonster | | | | | |
Onionflyhighhigh | | | | | |
Oninmissedpotato | | | | | |
Handbagcansing | | | | | |
Handbagoutdated | | | | | |
Toyknowsfashion | | | | | |
Cosmeticbeauty | | | | | |
Costmeticicecream | | | | | |
Toydreamsoftea | | | | | |
Lettuceguy | | | | | |
Orangejuicy | | | | | |
Shoeshatesocks | | | | | |
Shoesspeakchinese | | | | | |
Jacketdancer | | | | | |
Musechocolate | | | | | |
Lionking | | | | | |
Lionrabbit | | | | | |
Potatogame | | | | | |
Orangejacket | | | | | |
Onionmarrieslettuce | | | | | |
Shoestoetips | | | | | |
Cosmeticdancer | | | | | |
Musemomkitty | | | | | |
Toystory | | | | | |
Pandababy | | | | | |
Tigerrocket | | | | | |
Table2
ProductFamilyName | Code | ProductName |
Zoo | Zoosection1 | Tiger |
Zoo | Zoosection2 | Panda |
Zoo | Zoosection4 | Tigerfish |
Zoo | Zoosection3 | Muse |
Zoo | Zoosection1 | Lion |
GroceryMkt | GroceryMktsection1 | Tomato |
GroceryMkt | GroceryMktsection1 | Potato |
GroceryMkt | GroceryMktsection2 | Orange |
GroceryMkt | GroceryMktsection1 | Lettuce |
GroceryMkt | GroceryMktsection1 | Onion |
DeptStore | DeptStoreSection1 | Jacket |
DeptStore | DeptStoreSection2 | Shoes |
DeptStore | DeptStoreSection2 | Handbag |
DeptStore | DeptStoreSection3 | Toy |
DeptStore | DeptStoreSection4 | Cosmetic |
