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

    Creating a Relationship that uses PatternCount


      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?