Search Data Services
Meta Search
search across all the following databases:
Data Catalog
Data and documentation
KnowledgeBase
Common questions and answers.
Resources
Entire collection of data resources.
Latest Data News
Imagining a Census Survey Without a Mandate
Lessons from North of the Border
Nerd Alert: Dictionary of Numbers
Data Services Knowledge Base
Q:
I have an excel file that I want to join to an Arcmap template. My file has a 'previous sample' column that has 1 and 0 values in it. Every time I try to do the join the 'previous sample' variable is not listing in my attributes table. What is going on?
A:
When you have values that start with a leading 0 they will be dropped as a default. To maintain those numbers you will need to define the cell as 'text'. You can do that through the format tab in excel.