Hi
Let me know, how to convert a Household roster to single case file in a batch file mode. Also, I want create a case id (HH id + member id).
Thanks advance.
Prabhu
HH Roster to single case file
Forum rules
New release: CSPro 8.0
New release: CSPro 8.0
Re: HH Roster to single case file
There area a few steps involved:
- Add HOUSEHOLD_MEMBER_NUMBER to roster (if it doesn't already exist)
- Create and run batch that fills the field with the curocc for each person in the roster
- Export the the data file to CSV (see below for settings)
- Create new dictionary with HOUSEHOLD_MEMBER_NUMBER as id item
- Convert CSV to an Excel file
- Use Excel to CSPro to read in Excel file and convert to the new dictionary's format
- Id items ..., household number, household member number
- Each person (from roster) as its own case
- Each person's case will also include the singly occurring dwelling record data (in my example)