matpj

Using GEL for an iterative field matching process

Discussion created by matpj on Oct 12, 2010
Latest reply on Oct 12, 2010 by Dave
Hi all,
I have a bit of an issue that I need to solve - probably using some kind of stored procedure, I guess, but I wondered if it can be solved using GEL.

I have a query that returns several rows of financial transactional data.

For each row that is returned, I need to compare the row with another table (GL_Distributions - custom object) in order to find the 'best' match.

The table contains 8 fields - some of which are populated with *'s (which denote a wildcard)
Basically, I need find the best match (i.e. the row in the GL_Distributions) that matches with the most fields.
The process should go through every row in the GL table until it has found the best match. so if it cannot find a match on all 8 fields, it will try to match on 7, then 6 etc.

Does this sound like something I should be doing in a stored procedure within Oracle? or am i barking up the wrong tree.
Has anyone on here done anything similar? If so, some guidance would be much appreciated.


Thanks in advance,
Matt

Outcomes