Associating / Mapping Fields to Values using reference code list
I have a question about using mapping tables to create a data model to capture survey data.
I'm working with 3 Excel files (examples below and excel doc attached). Basically I need to use these data and mappings to produce a chart that allows me to see the survey data with the text for both the question and answers by person/respondent and aggregate the results by question.
I've done a lot of reading on mappings and have tried transposing the tables to have the columns match but I can't figure out how to actually link all 3 tables. The result file is giving me issues. Any help is GREATLY appreciated
1. Questions in survey with 2 columns Question_ID and Question_Text:
Are you interested in receiving information on the following topics?
Alcohol and other drug use
On how many of the past 7 days did you get enough sleep so that you felt rested when you woke up in the morning?