You Asked
Hi Tom,
I have a below scenario.This is not fixed and it is dynamic in nature
APPLICANT_NAME,Renewal_NAME,NUMBER,TYPE,SUBTYPE,ETHNICITY, GENDER,ZIP_CODE,QUESTION_id,ANSWER_Id,Answer
JAN,LR-001352966,LPN.039005.MEDS-IV,Licensed Practical,,White,Female,43824,Q-000559,A-000559,Yes
JAN,LR-001352966,LPN.039005.MEDS-IV,Licensed Practical,,White,Female,43824,Q-000686,A-000686,Yes
JAN,LR-001352966,LPN.039005.MEDS-IV,Licensed Practical,,White,Female,43824,Q-001483,A-001483,No
and I want output like this
APPLICANT_NAME,Renewal_NAME,NUMBER,TYPE,SUBTYPE,ETHNICITY, GENDER,ZIP_CODE,QUESTIONid_1,ANSid_1,ANSWER1,QUESTIONid_2,ANSid_2,ANSWER2,QUESTIONid_3,ANSid_3,ANSWER3
JAN,LR-001352966,LPN.039005.MEDS-IV,Licensed Practical,,White,Female,43824,Q-000559,A-000559,Yes,Q-000686,A-000686,Yes,Q-001483,A-001483,No
Thanks,
Nirakar
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment