AnsweredAssumed Answered

Compare records to filter out data

Question asked by christiaanvw@absi.nl on Nov 15, 2016
Latest reply on Aug 8, 2017 by SARANG GAIKHAR

Hi,

 

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.

 

Resource | model_number | starting_date
R000022   | 1                          | 01-01-2016
R000022   | 3                          | 11-11-2016
R000022   | 1                          | 22-05-2016

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:

 

Resource | model_number | starting_date
R000022   | 1                          | 01-01-2016
R000022   | 3                          | 11-11-2016

 

I cannot change the database query and I prefer not to script the process.

 

Thanks in advance!

Outcomes