8 Replies Latest reply: May 15, 2014 10:13 AM by Olly Bond RSS

    External Lookup problem - 1:1 Relation

    Oli _

      I've got 2 files which I like to combine.

      The colums of the fields are separated in the example below with "|"

       

      1. File:

      Art-Nr | Date

       

      2.File:

      Art-Nr | Date Beginn (Period)| Date End (Period) | value

       

      In both files are duplicates of the "Art-Nr".

      In the 2. File are for duplicates of the Art-Nr different periods (Date Beginn (period) | Date End (Period) with different values

       

      Now I like to have as a lookup the corresponding "value".

       

      How can I give Monarch the information which Relation is the correct value ?

       

      Art-Nr  <-> Art-Nr

      Date  <-> within Date Begin (period) <->Date End (Period)