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

Alteryx Knowledge Base

Definitive answers from Designer experts.
New Data Science Blog

Check out the latest post: All Models Are Wrong

READ MORE

Cross Tab Without Alphabetical Order

Alteryx
Alteryx

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.

 

CT1b.JPG

Output:

CT2.JPG

Comments
Meteoroid

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.