Forum Discussion

Ben_G's avatar
Ben_G
Frequent Visitor
4 years ago

Counting multiple matches

Hi. New to this forum so hope my post is clear. I have a table of campaign formats: Format Digital HPP SPP Others I have a table of campaigns which can have 1 or more formats (NB...
Need Help
Ben_G's avatar
Ben_G
Frequent Visitor
4 years ago

Hi Fowmy Thanks for the prompt response.
Additional info. I provided a small subset of data. However some of the entries in my full list of campaigns comprise 2 words (eg New Channel) so splitting by space delimiter may not be effective.
Any thoughts?

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    Ben_G 

    There has to be a logic and consistency in that case. If you can somehow identify the list of campaigns, it will solve the problem.
    Please let me know if you have any suggestions as you are familiar with your dataset.