Minimum date value

David Paras

• October 04, 2013 16:43

Is there a way I can query a minimum date value to store as a variable to use in my process?

Input Data

Policy No Policy Date Coverage Name Product

123 2010 01 James LTC

123 2010 03 James PTC

123 2010 02 James STC

123 2013 01 James LTC

123 2013 02 James STC

123 2013 03 James PTC

Our current key says to take the last occurrence for each Policy No and Policy Date combination. In the above example the map would create two records to write to our database:

Policy No Policy Date Coverage Name Product

123 2010 02 James STC

123 2013 03 James PTC

This is working as expected still.

The source information is stored in an Access Database format. What I want to do is still create the records as is, however there are certain attributes from the 2010 that I want to carry over to the 2013 record. For example, I always want to use the earliest (or minimum) policy date for all occurrences of Policy No 123 – regardless of what is being sent in for the Policy Date value the source file.

So what I really want to create would look like this:

Policy No Policy Date Coverage Name Product

123 2010 02 James STC

123 2010 03 James PTC

0

• 

  David Paras

  • October 04, 2013 16:45

  1) Apply for-each at the record level for the source record.

  

  2) At the record level, apply sorting rule on 'Date' element in ascending order.

  

  3) At the record level apply an IF condition in the textual rules as given below:

          IFF CONDITION{ position() = 1} VALUE=[ 'true']
  

  4) Apply mapping at the Date element with the value 'Date' in the textual rules ( we don't need to provide the full path for source element as we have applied for-each on the record node).

  0

Post is closed for comments.