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,