Forum Discussion

UBComma's avatar
UBComma
Icon for Helper III rankHelper III
3 years ago
Solved

Create new records from keyword list

AlexisOlson or BA_Pete   Any chance you would have a thought on this? I am trying to add a new column and new records to a table based on whether a list of keywords exists in the 'Title cleaned' col...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    3 years ago

    You can link to a cloud file using e.g. Dropbox/Google Drive/SharePoint/OneDrive. Make sure the file doesn't contain any sensitive data before you make it public.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

if you turn that list into a one column table, you can then add a column which uses each Table.FindText. This will bring in the whole row if it finds your text anywhere in the row.

 

--Nate