1 Reply Latest reply: May 15, 2014 10:08 AM by Data Kruncher RSS

    Multiple External Lookups

    bminer _

      Hi,

      I'm using Monarch Pro v9.01, and trying to use 2 external lookups by xlsx files.  My first external lookup works fine.  But when I add my 2nd external lookup, the data seems to shift, and the values are not going under the proper header (for example, under an address field, in some records I may have city, some state, some other random data).

       

      Does anyone know of a fix to this?

        • Multiple External Lookups
          Data Kruncher

          Hello and welcome to the forum bminer.

           

          I've never experienced what you've described, and I use plenty of models with multiple external lookups to xlsx files.

           

          I'd be tempted to test with csv files instead of xlsx. Open the files in Excel and save as MS-DOS CSV, then rebuild your lookups to use the csv files.

           

          If you're still seeing odd data in the fields, you might want to verify that those values are really in those fields incorrectly. Garbage In Garbage Out and all that. :confused:

           

          As I say, this is unusual behavior. While rare, it's possible that the model is corrupt. Rebuilding a model from scratch when you know what you want to structure really doesn't take too long at all usually, so you might want to try that too.

           

          HTH,

          Kruncher