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?

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.


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.



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.


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.



Login or Signup to post a comment