2 Replies Latest reply on Apr 7, 2016 9:16 PM by fmdataweb

    Creating a Relationship that uses PatternCount

    fmdataweb

      I have 2 tables - one table has records with a field with a name in it and the 2nd table has records with a field which contains a number of names.

       

      Here's an example:

       

      Table A - Name Field = "Johanson"

       

      Table B - Names Field = "Peterson, Johanson, Smith"

       

      I'm trying to create a relationship that will match any records in Table B which contain "Johanson" in this example, so we can show a portal of possible records to check.

       

      The Names field in Table B is very unstructured but if I switch to Table B and use the PatternCount function that does work, e.g.

       

      PatternCount ( TableB::Names ; "Johanson" )

       

      There will be hundreds of records imported into TableA so we would simply like to import them and see if anything matches. We can't create a simple = relationship predicate, but there's no option to do a "contains" predicate.

       

      Anyone have any ideas how we can get this working?