Forum Discussion
Solved
Unpivoting the data
Hi Everyone, I need your support. I am working on a small project and the raw data is attached. This is an online customer interaction platform. The customer register as a friend and they will get ...
1. Right click the table, then "edit query" to open the Query Editor
2. Highlet USERID and Conversation Count, then Transform->Unpivot Columns-> Unpivot other columns (see screenshot)
3. Rename "Attribute" as "Status"
4. Create a conditional column as seen here for "used"
5. You can add a "given" column the same way
1. Right click the table, then "edit query" to open the Query Editor
2. Highlet USERID and Conversation Count, then Transform->Unpivot Columns-> Unpivot other columns (see screenshot)
3. Rename "Attribute" as "Status"
4. Create a conditional column as seen here for "used"
5. You can add a "given" column the same way
