Assure DQ

Is there a function within Assure that we could leverage during matching that would attempt to match a “left” item field to an inconsistent portion of a “right” item field.

For example, “left” item Field A = 123 and “right” item Field B = 123456789 OR 456123789 OR 456789123.  Both items contain 123, but the right side may or may not be in the same place day to day.

We want to take the left item value and scan a larger right item value for the left value, and then match if it is found.

Thank you.

Hi Felicia,

One solution will be to create a match-and-merge task within the CP. Once established, look for the "match when" section; The team may utilize "t_contain" functions ( example : "t_contains(lef.string, right.substring" ) to accomplish what you describe.

Matthew Kennedy