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

    Missing Info from an External Look-up

    AmyS _

      I am using a key to match up information from one report to an external look-up of another report.  The key is a combination of two fields, vendor + sub-category.  The list of vendors in the first report does not show all of the vendors in my external look-up.  So, I am missing information in my Monarch table.  I tried to layer a master vendor report with my initial report, but I need to use two different models because the report formats are different, and I haven't been able to get that to work.  Any suggestions?  Thanks.

        • Missing Info from an External Look-up
          Data Kruncher

          Hi Amy. Amy that attended UC2008 Amy?


          Are you saying that you have more vendors listed in the current table window than are listed in the external lookup file (xls or mdb or what have you)?


          The lookup will generate null values for key combinations that it can't match in the lookup file.


          You'll need to do whatever it takes to generate a full vendor list in your external lookup file in order to be able to import data based on a common key via an external lookup.


          [URL="http://********************/xlreport/use-monarch-to-build-a-report-with-both-details-and-a-summary"]Nigel outlined a good approach that you might be able to use[/URL] to populate your master list. Essentially it involves creating a new table (overwrite option) with a first project file. Then with a second model/project, you recreate the exact field names and sequence as appear in the first model/project, and append that data to the output of the first file export.


          That will get you a good master list that you'll be able to use for your subsequent external lookups.