Is it possible to compare multiple records in a document (or split document) and filter out records you don't need?
For example, assume I receive the following data from a database.
In this example I only want unique model numbers or, if not unique, the model number with the first starting date to continue through the pipeline. In this case, is it possible to compare the starting dates from the records with the same model number to filter out the lowest starting date? I.e. I'd only like to keep:
I cannot change the database query and I prefer not to script the process.
Thanks in advance!