Please find the enclosed sample files I have set of 8 Questions (in old sample file) for which AnswerId were 1 Yes 2 No 3 No feedback
Everything was fine I was fetch the questions based on the following in my script while loading if(Num([Question No])>0 and Num([Question No])<10,'Q'&[Question No],'') as Question_No All calculations was based on Question_No field.
But in the enclosed updated sample file, user added one new question after QuestionNo 4. which act as sub questions for Q4. i.e 5,6,7,8 Now the Question No. sequence is changed as compare to old sample file.
Still there are basically only total 8 questions in both files, only updated file is having the new subquestions of Q4, where sequence as compared to old is changed.
The requirement is:
If the answer for Q4 (in updated sample file ) is "NO" then only Subquestions Q-5,6,7,8 comes into picture. Again subquestion Q-5 can have Answer as Interior/Exterior
If subquestion Q-5 Answer is "Interior" then subquestion Q6AnswerID need to be consider which is comma seperated, as mentioned in breakup sheet of updated sample file
AnswerID If Washing Concern is Interior Cleaning"" ======== =========================================== 1 Dash Board/AC Vents/Glove Box 2 Combimeter/IRVM/Ashtray/Sunvisors 3 Steering Wheel/Switches (Wiper/H Light) 4 Gear Lever Knob/Center Console/Stereo 5 Door Trims/Cupholders/Scuff Plates 6 Seats/Seat Belts/Buckles 7 Foot Mats/Floor Carpet 8 Roof Lining/Support Handle 9 Interior vacuuming 10 Not Answered
If subquestion Q-5 Answer is "Exterior" then subquestion Q7 AnswerID need to be consider which is comma seperated,as mentioned in breakup sheet of updated sample file
AnswerID If Washing Cocern is Exterior Cleaning"" ======== =========================================== 1 Windshield (FR/RR) / Window/Quarter Glass / Mirrors 2 Lamps (Head / Fog / Tail) 3 Engine Hood Panel/Front Grill 4 Roof Panel 5 Body Panel (Fender / Quarter/Rocker Panels) 6 Door Panels (Front / Rear / Dicky) 7 Bumper (Front / Rear) 8 Tyres/ Wheel Caps/Wheel Housings 9 Underbody/Engine Room/Boot Space 10 Not Answered
If subquestion Q-5 Answer is "Interior,Exterior" then both subquestion Q6,Q7 AnswerID need to be track
Note: Need to maintain the QuestionNo sequence number same as given in old sample file. As there is huge data available in olderfile for consideration.
Please suggest how to load the data so that we can maintain and track the above records with compare to old sample file and generate graph as given in "breakup" sheet of "Updated sample" file.
