3 Replies Latest reply: May 15, 2014 10:13 AM by elginreigner _ RSS

    External Lookup

    Oli _

      I've got the problem by using an external lookup.

      I have got 4 Colums in an excel sheet:

      Bukr-RE| Konto| BuKr-H|value

       

      and a model in Moarch which has the relevant information in the first 3 colums of the model (table view)

       

      Bukr-RE| Konto| BuKr-H|

      and I like to lookup the value colum of the excel sheet.

       

      I got some correct values in the monarch model via look up. But there are some cells empty which has to be filled with the corresponding information to the excel file.

      It seems that only the first data which were for found for this setup, shows the correct value

      Bukr_RE <-> BuKr_RE

      Konto <-> Konto

      BuKr-H<->BuKr-H

       

      For further values of the file with the same constellation, but the third check criteria is different:

      Bukr_RE <-> BuKr_RE

      Konto <-> Konto

      BuKr-H<->BuKr-H ..... Other values, but are corresponding to each other

       

      with the result that the cells doesn't get the value.

       

      What can I do to give Monarch the information it needs, that all values are shown in the model.

       

      Hope you understand the probelm.

       

      KR

      Oli

        • External Lookup
          elginreigner _

          Hoping I understand your issue correctly. For the lookup, are you stating there are multiple results that can be returned for the same lookup criteria? And you want to return the 2nd, 3rd, etc values to the alternative records?

            • External Lookup
              Oli _

              For Example

               

              My Model has the following information:

              Bukr |Konto|BuKr-H| Value

              S035|85739|S036|....

              S035|85739|S037|....

              S035|85739|S038|....

               

              In My Excelfile I have the relevant information which I like to have in my model:

               

              Bukr |Konto|BuKr-H|Value

              S035|85739|S036| 100

              S035|85739|S037| 325

              S035|85739|S038| 401

               

              Now I made an external lookup to my model with this excel file. By selecting the three criterias:

              BuKr<->Bukr

              Konto<->Konto

              Bukr-H<->Bukr-H

               

              and click the value.

               

              Unfortunately the result is, that only the first value is the result in my model. What can I do more to advice Monarch show all values ?

               

              Bukr |Konto|BuKr-H|Value

              S035|85739|S036| 100

               

              Hope this makes it easier to understand.

               

              KR

              Oli