9 Replies Latest reply: Feb 4, 2015 2:17 AM by Michael Jansen RSS

    Load/Join data based on valid from date

    Michael Jansen

      Hello,

       

      is there anyone who can help me with the following Problem?

       

      I have two tables

       

      one with documents containing a Costtype and a CreationDate

      DocumentTable

      1.png

      and one with costs per costtype depending on a valid from date

      CostTable

      2.png

       

      and I would like to get the following result tables with documents with correct cost depending on the Costtype and CreadtionDate of the document

      ResultTable

       

      3.png

       

      But I can't simply join them, because there is no excact match in both tables.

       

      So, is there something like a conditional lookup function I can use?

       

      regards

       

      Michael