Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Option for a crosstab to return an error when aggregating values

Hello

 

I have searched the community but haven't found any obvious solutions to this.

 

When using a cross tab I often find that there shouldn't be any aggregated values and if there is it means there is an issue with my data or workflow.

 

Therefore I think a useful feature would be an option for the cross tab tool to be able to return an error if it trying to aggregate any values.

 

I have a work around by using a summarize tool to count the non unique records and then a test to see if there are any duplicates but I think this could be a useful addition to the tool.

 

Thanks

2 Comments
CristonS
Alteryx Alumni (Retired)

hi @Matteop9, your idea and feedback are appreciated! Our product team is constantly striving to make our products better, and the user feedback we receive is critical in that mission. We recommend checking out our Submission Guidelines as they go into greater depth on the criteria needed for an idea to reach our product team, as well as provide info on the boards in general. Make sure to also check out other users' ideas! 

 

 

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes