community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Cross Tab Without Alphabetical Order

Alteryx
Alteryx
Created on

To avoid the transferring all the input information alphabetically in the Cross Tab Tool, you can add a RecordID for all the records of the input.  Then add RecordID as the Grouping Field in the Cross Tab Tool.  

 

Input:

CT1.JPG

 

 

Add RecordID.  Then in the Cross Tab tool, group by RecordID.

 

4crosstab.jpg




Output:

CT2.JPG

Attachments
Comments
Meteor

Hi ,

I have following queries.

 

1)I wanted to search the data of one column whether it is existing on other column or not. How do I do that

2) How to add new column to existing columns in output file dynamically

 

Regards,

Prasad.