Dear CSPro Team,
I have repetitive survey entry for some household. Every month or after 10 days we have to survey these households.
For this I have made unique key is HHNo. and Date.
But by external dict I want to retrieve latest household information which is previously filled by the enumerator.
How can I extract information from previously filled household information.
Here I am using MAX(DATE) function but not able to retrieve information.
If there is another way to retrieve information from the household then suggest me how?
Get data from external File
Re: Get data from external File
It depends on how your data is stored in the external file. Do you have each of the previous interviews stored as a separate case or do you have all the previous interviews stored in the same case?
-
- Posts: 63
- Joined: May 15th, 2018, 1:18 am
Re: Get data from external File
All are in seperate case
Re: Get data from external File
Then use forcase to loop through the cases in the external dictionary and pick the one with the most recent date.
-
- Posts: 63
- Joined: May 15th, 2018, 1:18 am
Re: Get data from external File
Thanks it works