Receiving a XML file that contains multiple line item segments whereas each one would get segments that look like the following (diff values per line item of course):
Got this converted to an IS document. No problem with that. This is strictly a mapping question that I have.
The mission: Only map the lines above that have a that is unique and if it does happen to appear more than once, only map the line that contains the latest docNumber match, so in the above, I would map line 1 because it contains a unique docNumber 1111111 and I would have to map lines 4 and 5 because even if the number is not unique, I am to grab the latest (last) segment that contains the match. Lines 2 & 3 wouldn’t get mapped at all, because they are not unique and /or considered the latest match.
I cannot figure out the best way to approach this. I tried searching the forum, but don’t think I’m using the right keywords or something, because I can’t find this type of question answered. Thank you for any suggestions!