Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity 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