I think I'd suggest you start with a simpler example. From what I can tell from message 9, you're looking at 17 rows of output from a single input line, correct? Pick a simpler example: One source record and maybe 3 output records, explaining how/why those 3 records were selected and all others not. That might lead us to figure out a general rule: Source record results in the selection of one result, that resulting record is then used as the source to find the next result record and so on. Walk us thru your logic. For me, it's very hard to follow what you're starting with and what you want to finish with.
... View more
