Forum Discussion
How to flatten 2x rows into one
Hi
I have an app which i'm reporting survey results out of. As you can see, the rows become uplicated based on result_type. If result type = 0, individual is assessing, if result type = 1, validator (2nd person) is assessing them.
Question in the picture attached is the same question which I need 1 row for.
I need to combine all of this into one row.
Each result row comes in as follows
result_id | response_id | question_id | result_type | answer
Depending on the answer value, I have a custom column to create a development flag if answer is <= 2. However answer can be <=2 for both result types which creates separate rows. I would like this to be in 1 row as these are being double counted.
Have attached rudimentary picture and entity diagram.
1 Reply
- v-kkf-msft
Community Support
Hi Anonymous ,
I couldn't understand the final result you want to achieve, could you please give me a concrete example?
Each result row comes in as follows
result_id | response_id | question_id | result_type | answer
Depending on the answer value, I have a custom column to create a development flag if answer is <= 2. However answer can be <=2 for both result types which creates separate rows. I would like this to be in 1 row as these are being double counted.
Best Regards,
Winniz