Matching words in a Column to Fill out a Table

[dmc141]

I have two tables which both have the same KeyID columns as shown below. Now, depending on the values in the Activity column in Table 1, I want to be able to fill out Table 2 in a 'smart' way.

For example, in Row 1, Activity has 'Creating Items', so since the word Creating is similar to Manufacturing, I put 'True' in the Table 2 row for those KeyIDs
For Row 2, since Activity says 'Research studies and making items', this means the Research and also the Manufacturing cells have True

For Row 4, since Geology does not fit into any category, it goes in Other. This results in the final table as follows:

 

Is there a way to do this kind of thing in Alteryx? I have attached the Excel too, thanks in advance!

[OTrieger]

@dmc141 

Potentially you can, but it means that you will need to create a list for each header with all the possible keywords and keywords combinations that will give you a true statement and then do a formula with the IF contains. Alteryx will not be able to think, so any possible key words will need to be created

[Raj]

@dmc141 you will need a file where you can associate the words with the headers
for example creating - manufacturing and all

else this is difficult to achieve.