Start a new topic

Regular Expressions for Relationships

In our import we have the reciprocal relationship, but no relationship field. So we do not have to manually enter each relationship, we would like to see if we can use an expression. For example: If reciprocal= daughter and gender of relationship= female then relationship=mother. Is this possible? If so, does anyone have the formulas?

Hi Ashley,


This would not be possible with regular expressions as it requires analyzing data from two fields.  Regular expressions can only manipulate data based on the value in one cell at at a time.  It would be possible through a customization in the IOM API.


Thanks,


John

Hi John,


Would give us a little more information about the IOM API customization, please? Is this similar to the code we had your team build so we could match on address?


Thank you so much.

Christine


Yes, it would be similar to that.  We could write logic into your profile that would look at the values in multiple columns and assign the relationship value based on the criteria you give us.


Thanks,


John

You may want to simplify your relationships to being non-gender specific. For example we use Spouse, Parent, Child, Grandparent, Aunt/Uncle, Sibling, etc. It makes it easier when you don't have gender info or unisex names.

 

Login or Signup to post a comment