Nikki Nagarkar

Nikki Nagarkar

  • 1.9k
  • 69
  • 5.8k

Row TO Columns based on Formid (ID)

Feb 4 2019 4:13 AM
i have extracted data from console application by reading the 2 to 3k XMls and stored in database in  following form (sample Data).where  ihave change the rows to columns based of formid .
if particular form id do not have  question _(dash ) should be displayed.
 
Question ID Form Id Question Answer
1 1 Do you Smoke yes
2 2 Do you have asthama yes
3 1 Do have Bo above 330 No
4 3 Do have Bo above 330 yes
5 1 Do you have asthama No
6 2 Do you Smoke No
7 3 Do you have asthama yes
8 2 Do have Bo above 330 No
9 3 Do you Smoke yes
10 1 do you have vitamins alergy yes
11 3 Allery with antiblotics yes
 
 i want following output
 
formid Do you Smoke Do you have asthama Do have Bo above 330 do you have vitamins alergy
1 yes No No yes _  
2 No yes No _ _  
3 yes yes yes _ yes  
 

Brought to you by:

Answers (2)