I want to find if the given elements under a group are the part of another string or no ? If they are then I want the group number of the string where it was the part. They should be part of another string.For example, 'Benefits, verify' is one string under group 1 and that is part of group 2 string (claims,verify,benefits,verify). I also want to count how many times it appears in another string. Additional : Do not include the single words in calculation. For example in the below example do not include benefits in calculation. For example Column1 group Benefits,verify 1 claims,verify,benefits,verify 2 inquiry,type 3 claims,verify 4 Benefits,verify,inquiry,type,Benefits 5 Benefits 6 Benefits 7 Output expected: column1 Part of group count Benefits, verify 2 2 Benefits,verify 5 2 claims,verify 2 1 inquiry,type - - claims,verify,benefits,verify - - Benefits,verify,inquiry,type,Benefits - -
... View more
