I have a table in a geodatabase with an ID and a text field for each day of a week. The text fields contains 0 or 1 for monday, 0 or 2 for tuesday, and so on. One ID can have multiple day entries, so for every day, or only on weekends,...

I need to join this information to another table. It contains a Name, and the ID of the first table. At the end, it should have the following fields: Name, ID, Day. and the day information are coming from the seven "day-fields" and if one ID has multiple day entries it has to be duplicated.

Is there a possibility to do this, or do I need to create seven distinct tables and re-assemble them afterwards?

I am using ArcGIS 10.1 for Desktop.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.