LOOKUP VALUESETS
Posted: November 12th, 2017, 4:59 pm
Hi All,
Thank you for always assisting me in my hour of need. Once again, a have a challenge that I require your support to pull through. I have a mapping exercise that is going to cover a large number of communities across different geopolitical regions. I want to design a data entry application with a dynamic valuesets to limit enumerators within a list of communities under a region (Ward) earlier selected.
To do this, I have, many time tried to convert the said data values from excel to *.dat file, but what I keep getting is a list of 11 communities instead of the actual number as contained in the attached excel file. I'm not sure what I have gotten right yet, but I do know that the 11 conversions are based on the number of unique codes (Ward_Code). Please help.
Thank you for always assisting me in my hour of need. Once again, a have a challenge that I require your support to pull through. I have a mapping exercise that is going to cover a large number of communities across different geopolitical regions. I want to design a data entry application with a dynamic valuesets to limit enumerators within a list of communities under a region (Ward) earlier selected.
To do this, I have, many time tried to convert the said data values from excel to *.dat file, but what I keep getting is a list of 11 communities instead of the actual number as contained in the attached excel file. I'm not sure what I have gotten right yet, but I do know that the 11 conversions are based on the number of unique codes (Ward_Code). Please help.