I have a scenario. I have two tables. A form table and a form answers table that are linked via an ID.
Form ID Form Name Date of Form
555 wlejr 15/10/18
Form ID Question Mapping ID Question Answer
555 124214 Do you like... Yes
555 13456 Do you need... No
To save server resources we only bring in those answers for forms where they are completed. However I want to identify forms that have missing answers to questions for data quality. There are over 100 questions in the form and I want to identify which Questions have missing answers.
Can anyone suggest how to get around this? I was thinking using a master mapping list of the IDs but I can't do apply maps on 100 questions to see if there is an answer and I don't want to have to name fields manually by hand.
I need something that looks into all the Question Mapping IDs and identifies whether that form ID has an answer and spits out which questions does not have answers.
I hope that makes sense and I can provide more details if you need!
I need to know which forms have which answers missing