Community Groups are officially here!
We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.

Regenerating QID column names of exported response data from metadata

lyh970817
lyh970817 UKCommunity Member Qubie ✭
edited July 2020 in Integrations

I'm writing an R package to facilitate data dictionary generation and cleaning for exported Qualtrics response data. I would require a way to regenerate QID column names from the metadata json. I'm wondering if I could find a spec on how Qualtrics platform does this?

Answers

  • w.patrick.gale
    w.patrick.gale Community Member Guru ✭✭

    @lyh970817 Are you looking at the survey export file (.qsf)? This is the data dictionary for your surveys. Simply rename the file to .json (since it is a JSON file).

  • lyh970817
    lyh970817 UKCommunity Member Qubie ✭
    edited July 2020

    Sorry I was not being clear in the question - I'm referring to exported response data with column names like these:

    "QID124934938"     "QID124931340"

    "QID124931341_0"    "QID124931341_1"

    "QID124931341_2"    "QID124931341_3"


    I believe the QIDs extracted from elsewhere do not have these "_[0-9]+" appended. So I'm wondering how to match the metadata to these response data columns.

  • w.patrick.gale
    w.patrick.gale Community Member Guru ✭✭

    @lyh970817 Check the .qsf file. All of the default IDs and any recoded IDs should be in the .qsf file. Again this file is the best source for defining the survey.

  • lyh970817
    lyh970817 UKCommunity Member Qubie ✭
    edited July 2020

    Thanks! I think in the qsf file there are QIDs like "QID124931341" and its recode levels, subquestions etc. but it's not very straightforward to combine them into exactly what exports as the QIDs appearing in the response data file. It depends on the question type and selector etc.