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!
