Get data from external File

[Bhupender11]

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?

[josh]

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?

[Bhupender11]

All are in seperate case

[josh]

Then use forcase to loop through the cases in the external dictionary and pick the one with the most recent date.

[Bhupender11]

Thanks it works