Instances and Arrays in Table Exporter

Nicholas Edward Souter

Hi everyone,

I've been using Table Exporter to extract some variables. So far this has been going succesfully, but I'm running into issues when trying to request variables that are both instanced and arrayed. Specifically, I'm struggling with:

6138 - Qualifications

6141 - How are people in household related to participant

Both seem to be instanced and arrayed, so should be in the format p6138_i0_a0, etc.. However, I'm getting the following error message: 

“Failed to export data: Field name(s) not found: ['p6138_i0_a0', 'p6138_i0_a1', 'p6138_i0_a2', 'p6138_i0_a3', 'p6138_i0_a4', 'p6138_i0_a5']”.

Have I not specified these variables correctly? I've been able to successfully pull variables that are only instanced, or only arrayed, but nothing which is both instanced and arrayed.

Any help would be much appreciated.

Nick Souter

Comments

1 comment

Date Votes
  • Comment author
    Nicholas Edward Souter

    For anyone encountering this same issue, it's been solved on another thread. In short, some variables like 6138 and 6141 have been simplified for the RAP, such that they've been condenced to just be instanced and not arrayed. Accessed like this:

    p6138_i0
    p6141_i2

    Each value you get out is then a list. For example, for 6138 (qualifications):

    'College or University degree|A levels/AS levels or equivalent|O levels/GCSEs or equivalent|Other professional qualifications eg: nursing, teaching'

    So the different values that would have been separate arrays are now part of a single value.

    2

Please sign in to leave a comment.