Learn, collaborate and solve problems with like-minded data quality enthusiasts.
As part of our product discovery activities, we would like to find out if any of our clients have a use case for pivoting or unpivoting data. If you do, we'd like to hear about it. Please leave us a message and we'll get in touch.
Hi All, I have an issue with the pivot and I'm not sure how to solve this or what function to use to get a similar arrangement! I would like to arrange my dataset so that I see all vendors in one column grouped and all the other data columns arranged in further columns: Normally the column selected as the "pivot ID" should…
The group in the pivot is not working perfectly and it is not arranging the values into columns as it should. We noticed that it is when we also have a sort before the pivot step. We had the same issue in version 2.4 and it still remain in version 2.8.8. Has anyone else faced this issue? Have you found any work-around?
I have rule1, rule2, rule3 in the column names and corresponding count in the rows, now I want to get the result as Column Names : Rule, count How I can achieve this?
