The Group in the pivot seems not working perfectly

George_Stephen

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?

Josh Boxer

Hi George

I have not used the Custom step Pivot for some time as there are newer Native steps 'Columns to rows' and 'Rows to columns':

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-a-workflow/#columns-to-rows

https://community.experianaperture.io/discussion/819/aperture-data-studio-2-7-1

https://community.experianaperture.io/discussion/806/aperture-data-studio-2-6-10

These might possibly work better for your requirements.

If you still want to use pivot, can you please provide more information or a screenshot of the misaligned columns so that we can investigate