Keyword Search
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I have a table that contains with an entire column of free text. I have a list of Keywords that needs to be checked if it is in this column. Some sentences contain more than 1 Keyword. In this case, how can i retrieve all the keywords that are present in each cell and the entire column as well?
Please help!
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ben_d_jacob
I prepared a macro for this and would welcome your comment on it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The workflow work for a small dataset. I tried running for more data and got the below error message for all records. Does anyone know the reason? Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@JasonZhang_fb Yes, the macro which @Qiu has created contains the Append tool. By default, it will spit out the error on larger data sources like you have. You just need to change the configuration of the Append tool to 'Allow all appends'. See the picture attached
I've updated the file. Open the new file I've attached, it should work!
