Forum Discussion

ember17's avatar
ember17
New Member
2 years ago
Solved

Duplicate column values based on value in a different column

I have a dataset (see attached) with tens of thousands of Interaction IDs, many of them matching. I have the following columns: Friendly, Effort, Competent, Trustful, Empowering and Timely, and...
Need Help
Tips and Tricks
  • djurecic's avatar
    djurecic
    2 years ago

    Hi ember17 ,

     Do you want to duplicate data or have a single row per Interaction ID? For a single row per ID, you could try using SUMMARIZE to get the sum of each column by Interaction ID.

     

    Here is additional information:

    https://www.youtube.com/watch?v=IeaPNw_YuQc

     

djurecic's avatar
djurecic
Icon for Super User rankSuper User
2 years ago

Hi ember17 ,

 Do you want to duplicate data or have a single row per Interaction ID? For a single row per ID, you could try using SUMMARIZE to get the sum of each column by Interaction ID.

 

Here is additional information:

https://www.youtube.com/watch?v=IeaPNw_YuQc