What's the difference between the Cross Tab and Transpose tools?

1.	What's the difference between the Cross Tab and Transpose tools?
Answer» While the Transpose and CrossTab TOOLS both change the orientation of your data, their behaviour is completely contradictory. The Transpose tool transforms HORIZONTAL data into VERTICAL data. By summarizing the data on a GROUPING field, the CrossTab achieves the OPPOSITE, pivoting vertical data to the horizontal axis.

Answer»

While the Transpose and CrossTab TOOLS both change the orientation of your data, their behaviour is completely contradictory.

The Transpose tool transforms HORIZONTAL data into VERTICAL data. By summarizing the data on a GROUPING field, the CrossTab achieves the OPPOSITE, pivoting vertical data to the horizontal axis.

Discussion

No Comment Found

Related InterviewSolutions

What is the mechanism for determining the number of memberships to be distributed as a Data Artisan?
What is the difference between Alteryx and standard ETL tools?
What are the steps for sharing an application via social media or email?
How do you edit or remove a word or a character?
What is the best way to save an expression?
What's the difference between the Cross Tab and Transpose tools?
Are the users in a collection notified when we add a new application to that collection?
What kinds of applications can you include in a collection? What are the different types of users that can be added to a collection?
How can I locate the applications I require?
How do you modify the field type?

What's the difference between the Cross Tab and Transpose tools?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment