AnsweredAssumed Answered

Creating a Relationship that uses PatternCount

Question asked by fmdataweb on Apr 7, 2016
Latest reply on Apr 7, 2016 by 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?

Outcomes