Cross Tab Without Alphabetical Order

[AngelaO]

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:

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

Output:

[prasadpvrs]

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.

[Masaru_Hirose]

I would like to know about it, too.

I'm so pleased to teach me about the solution.

Thank you.

[Marg7]

Hello,

I'm a new user to Alteryx. I need help with sorting my data by date order after using the cross tab. Here is what I've been able to do so far. Please help. Thank You!

original file

Workflow

Would like the output to be like this...

[lepome]

@Marg7 

I would recommend you do this:

Make sure the dates are in Date format before you apply the Cross Tab.  That will put them in the correct order.  Then use a Dynamic Rename tool and a DateTimeFormat() formula to change the format of the dates to the Month dd, yyyy you desire.  (Disclaimer:  I have not actually tried this recently, but it "should" work.)

[Marg7]

Thank you LisaL. It worked! I appreciate your help.