Aha! Not sure how the extra spaces were inserted but they were in the State field. Does Excel have a reveal formatting option like Word? How did you find the extra spaces? It looks like I'll need to know that for future reference.
I spent way too much time trying to figure what I'd done wrong, so many thanks. -D ________________________________ From: "[email protected]" <[email protected]> To: [email protected] Sent: Monday, August 20, 2012 8:57 AM Subject: [Maptitude] Re: Not Mapping Some Data Hi: It looks like it is a case of extra spaces. Please go into your spreadsheet and remove the extra spaces for those 3 states. Maptitude Mapping Software Group Moderator --- In [email protected], Deborah Campbell <deborah_campbell@...> wrote: > > Yes, I've attached my spreadsheet and a jpg showing the map. As far as I can > tell the data for these 3 states is the same as the others. > > -D > > > ________________________________ > From: "[email protected]" [email protected] > To: [email protected] > Sent: Monday, August 20, 2012 8:24 AM > Subject: [Maptitude] Re: Not Mapping Some Data > > >  > Hi: > > This is almost certainly a data issue. Can you share the data? > Maybe the State values have extra spaces in them? What you > are describing is a join, and joins are exact, so extra spaces and > upper/lower case should be reviewed. > > > Maptitude Mapping Software Group Moderator > > --- In [email protected], Deborah Campbell deborah_campbell@ wrote: > > > > I'm creating a simple map of the US by Medicaid eligibility requirements. > > Can anyone tell me why the created map is not mapping 3 of the states? It's > > not color coding them but they appear as white and have been thrown in the > > 'other' category. The states are MO, CO, and AL. > > > > Thanks, > > -D > > >
