Hey all! I’m building a nutrition database and am trying to find a way to get it so that people can free type the foods they’ve eaten and they system will automatically do a ‘best guess’ match to assign it to the food. I’ve created a dummy doc to show you what I mean. It would be awesome if anyone…

Hi @Ben , Try with this: [List of ingredients example] .Filter(CurrentValue.Ingredient.Lower() .In( thisRow.[NLP identify].FormulaMap(CurrentValue.Name.Lower() ) ) ) The thisRow.[NLP identify].FormulaMap(CurrentValue.Name.Lower() part could be an additional column (…

Match text from one column with list from another table

Ben_Swanson September 3, 2020, 10:18am 11

Just to close this off, I figured out / hacked together a solution using @BenLee’s amazing work here.

Thanks again for your help!

1 Like

Topic		Replies	Views
In Table 1, can I search a column for text that exists in Table 2 and return a text in another column in Table 2 back to a new column in Table 1?	4	366	December 5, 2022
Filtering from one table to match another	3	333	March 31, 2022
Search any from list pasted in text control	4	35	August 6, 2024
Seeking help with Formulas	4	264	June 4, 2023
Find match in string	2	1586	January 28, 2021

Match text from one column with list from another table

Related topics