• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by Micro Bot


29 Nov, 2024

Updated at 02 Dec, 2024

Asssign category based upon text in a field

Hi - I am looking to do the following :

(I posted this question before but cannot seem to locate it!)

 

I would like to assign a category to the master table (Master Table) based upon search criteria in another table (Table 1)

 

Example

Master Table (input)

IDTextCategory
1I like ice cream 
2Apple trees are growing in the yard 
3Here is a bowl of nuts 
4 I ate some ice cream on Sunday 

 

 

Table 1

 

Search TextCategory
Ice CreamDessert
CakeDessert
BananaFruit
AppleFruit
PetzelsSnack
NutsSnack

 

Final - Master Table (output) - search Text field so to speak and determine the category

 

IDTextCategory
1I like ice creamDessert
2Apple trees are growing in the yardFruit
3Here is a bowl of nutsSnack
4I ate some ice cream on SundayDessert

 

Any help would be appreciated - Jerry