1 Reply Latest reply: May 15, 2014 10:12 AM by KeyserSoze _ RSS

    One model two files?

    Marc Osborne



      Can I create a model that grabs data from two different files? I have a model that works with monthly average sales figures but it doesn't work well in the early months of the year as there isn't much sales information yet. I'd like to work with this model but have it grab last year's average monthly sales figures from another file and display that information in the current model. Somehow I'd have to tie that information to the SKU in case any of the current data order changes from last year's fixed order. Is this possible?





        • One model two files?
          KeyserSoze _

          Hi Marc,


          Yes, you can do what you want to do with Monarch. In fact, you might say that Monarch excels /Iat this sort of thing.


          You'll want to create a kind of master list of SKUs and the relevant average values that you want to track for each SKU. Store this in an .xlsx file and you'll be able to track more than a million SKUs in a single table. Use an Access database table if you need more than that. Of course you'll want to use Monarch to build that master list for you in whatever format you choose.


          Now in your current year model/project add an external lookup to the master list to bring in the related values that you need. At that point you can use summaries to analyze the data any which way you want.


          Keep in mind that you can use multiple lookup keys if necessary, but generally when working with SKU fields a single key is all that's required.


          Does this help to move you ahead?