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) ExampleMaster Table (input)IDTextCategory1I 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 TextCategoryIce CreamDessertCakeDessertBananaFruitAppleFruitPetzelsSnackNutsSnack Final - Master Table (output) - search Text field so to speak and determine the category IDTextCategory1I like ice creamDessert2Apple trees are growing in the yardFruit3Here is a bowl of nutsSnack4I ate some ice cream on SundayDessert Any help would be appreciated - Jerry

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)

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

Table 1

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

ID	Text	Category
1	I like ice cream	Dessert
2	Apple trees are growing in the yard	Fruit
3	Here is a bowl of nuts	Snack
4	I ate some ice cream on Sunday	Dessert

Any help would be appreciated - Jerry