Tagging multiple keywords group by different projects

knozawa

Hello,

I have a workflow that tags multiple keywords to content grouped by different projects.  This is done by a batch macro.  The workflow works fine when we tag by a small number of keywords.  However, when we increase the number of keywords, the workflow runs long time and sometimes gives us "unexpected error".

Is there a better way to tag multiple keywords so that the workflow process faster and more efficient?

Attached a sample workflow that contains a batch macro.

Input 1 (contents)

Input 2 (keywords)

Desired output

Sincerely,

knozawa

batch macro_filter multiple keywords faster.yxzp

knozawa

I've attached the solution workflow. 

Thank you all, especially @DanielBr from Alteryx support engineer helped me to solve this issue.

Batch macro vs regex with find replace methods:

Regex with find replace method was 1148 times faster performance because it processed only one time looking up keywords instead of looping multiple times.  Also, regex with find replace method had more matches because some of the contents did not have spaces between words due to Japanese language.

Two take-away for using regex with find replace method:

1. When contents contain keywords, only the longest keyword matches.

 

Contents = John Aaron Smith

Keyword 1 = John

Keyword 2 = John Aaron

Keyword 3 = John Aaron Smith

2. Potential mismatch for some keywords (i.e. "app" matches with "appliances" and "applications" not only "app")

As a result:

Batch macro method is suitable when:
1. Multiple keywords should be tagged for the same contents match (i.e. keyword 1, 2, and 3 should be tagged for contents = "John Aaron Smith")

2. List of keywords contains "short-length" keywords (i.e. "app")

Regex with find replace method is suitable when:

1. There are many keywords in the list to match

2. Words are not separated by spaces (i.e. Japanese/Chinese)

Hope this helps for people who have similar use cases.

Sincerely,

knozawa

Key words[28081]_sample_KN.yxzp