Skip to Content
0
Former Member
Nov 25, 2015 at 09:18 AM

How to use a Match Transform for comparisson 1 to N?

291 Views

Hi everyone,

When u use the Match Transform, it's true that I have the chance to use one inflow or two, but the way it works is the same (at least, that's what I was able to get).

For example, if I wanna compare a few similar records like this (Table 1):

ID CONTENT 1 JUAN 2 JUANA 3 JAN

With the records of a master table (Table 2) where there can be similar records too, like this:

ID CONTENT 50 JUAN 51 JUANA


The Match stage (obviously, deppending on the criteria you use) group all of them in one single group and this is a problem for me because, for example, I can't have proper similarity percentages.

What I would like to get is a comparisson 1 to N (from the first table to the second one). Something like:

TABLE1.ID TABLE1.CONTENT TABLE2.ID TABLE2.CONTENT SIMILARITY PERCENTAGE 1 JUAN 50 JUAN 100% 1 JUAN 51 JUANA 80% 2 JUANA 50 JUAN 80% 2 JUANA 51 JUANA 100% 3 JAN 50 JUAN 80% 3 JAN 51 JUANA 60%

Is that possible? How would I have to configure the Match Transform to do that?

Thank you in advance and best regards,

José