Forum Discussion
From Journal description common words idenfication
Hi, Is there way I can identify the common words across the journal description? Combined both decription and give me some thing coomon that can enable us to do the tax review. Alternatively just us...
From you example I ca't see how you came up with the values in your Keyword column. In several cases words appear in Keyword that are not common to the other 2 columns.
But!
Guessing what you want:
Split by delimeter " " the journal columns .
Do a List.Intersect of the 2 resulting lists.
Do a Text.Combine of the intersect with " " as a delimiter
Or alternatively, Expand the intersect list so you get a row for each keyword. This may be easier to analyse....