Could you pls check this error

[former_member800804]

I am getting the error "The pivot transform is being aborted, due to data collision." While I am using Reverse pivot Transform. What is the reason for this error??

[former_member27]

Hi Aravind,
Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.
For example, you can:
- outline what steps you took to find answers (and why they weren't helpful)
- share screenshots of what you've seen/done
- make sure you've applied the appropriate tags
- use a more descriptive subject line
The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html
Should you wish, you can revise your question by selecting Actions, then Edit.
By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html
Regards,

Dedi

[former_member800804]

This is the screenshot of the error which I got

[denise_meyer]

See Reverse Pivot transform options

Duplicate value - Action taken when a collision occurs. A collision occurs when there is more than one * with the same key and value in the Pivot axis column. In this case, you can store either the first * or the last * or you can abort the transform process.

Please check you data set to resolve this issue.