6 Replies Latest reply: Feb 27, 2014 3:45 AM by Antonin Ramet RSS

    Adding calculated field after IntervalMatch

    Antonin Ramet

      Hi there !

       

      I'm back with another problem. Yesterday, you helped me with the IntervalMatch concept, but now that I succeed with it, I can't use it.

      I searched for an hour now, and I still have trouble with the join functions.

       

      My script is the following :

       

      Mandat :

      LOAD Date([Year],'DD/MM/YYYY') as Date_reception,

      Montant

      ...

      from [.../Délais 2012.xls]


      LOAD Date([Year],'DD/MM/YYYY') as Date_reception,

      Montant

      ...

      from [.../Délais 2013.xls]


      Interval :

      LOAD * INLINE [

      date_from, date_to, taux_journalier, delai

      01/01/2008, 31/12/2008, 0.00016411, 45

      01/01/2009, 30/06/2009, 0.000246575, 40

      01/07/2009, 31/12/2009, 0.000219178, 40

      01/01/2010, 30/06/2010, 0.000219178, 35

      01/07/2010, 31/12/2010, 0.000219178, 30

      01/01/2011, 30/06/2011, 0.000219178, 30

      01/07/2011, 31/12/2011, 0.000226027, 30

      01/01/2012, 30/12/2012, 0.000219178, 30

      01/01/2013, 30/12/2013, 0.000212329, 30

      ];

       

      Intervalmatch:

      IntervalMatch(Date_reception)

      load distinct date_from, date_to  Resident Interval;

       

      But now, I want to create a field "IR", which is calculated by (Mandats.Montant * Interval.taux_journalier * Interval.delai).

       

      How can I make it ?

       

      Thanks in advance