3 Replies Latest reply: May 15, 2014 10:01 AM by Data Kruncher RSS

    Lookup with blanks

    DZizzo _

      I'm having trouble with a lookup to an Excel file.  Even if there is no data in the Excel cell, if Monarch finds a match on the key, it will import a "0" in fields that are blank in the Excel lookup file.  The funny thing is, I don't think it used to do this.  We went to Monarch 9.0 last year and have since put on the 9.01 upgrade.  Could that have made a difference?

       

      Thanks for any help.  Or ideas on how to work around it.  I've tried changing to strings and eliminating zeroes then changing back to values, but those pesky 0's keep showing up. 

       

      P.S.  I wish I was going to the conference this weekend.  I went one year and it was the best conference I ever attended.