Keyword Search

Question

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!

BS_THE_ANALYST · Answer

@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!

0419-ben_d_jacob_updateappend.yxzp

JasonZhang_fb · Answer

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

Qiu · Answer

@ben_d_jacob 
 I prepared a macro for this and would welcome your comment on it.

0419-ben_d_jacob.yxzp