Checking/Count Cases with Main Dictionary
Posted: September 24th, 2019, 4:43 am
Dear Cspro Team,
I have a situation I would like to first want check if a case exist in a file and at least a sub-string of it present in the file using the main dictionary, Not in an external dictionary , seems all the available functions such as forcase, locate, countcases works in an external dictionaries.
My example is my ID items are Cluster HH and MID, one can have multiple MID in a household, in this way I will like to first check if there is at least an existing case that has a substring of Cluster and HH after selecting HH, then I auto increase the MID for that particular household.
if cluster - 1 and HH - 1 if it does not exist then MD is 1 , if Cluster and HH exist then MID+1 (presume MID is sorted ascending). Kindly assist me in this regards
Thanks always.
I have a situation I would like to first want check if a case exist in a file and at least a sub-string of it present in the file using the main dictionary, Not in an external dictionary , seems all the available functions such as forcase, locate, countcases works in an external dictionaries.
My example is my ID items are Cluster HH and MID, one can have multiple MID in a household, in this way I will like to first check if there is at least an existing case that has a substring of Cluster and HH after selecting HH, then I auto increase the MID for that particular household.
if cluster - 1 and HH - 1 if it does not exist then MD is 1 , if Cluster and HH exist then MID+1 (presume MID is sorted ascending). Kindly assist me in this regards
Thanks always.