08-22-2017 12:05 PM - edited 07-09-2021 11:25 AM
Input:
Add RecordID. Then in the Cross Tab tool, group by RecordID.
Output:
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.
I would like to know about it, too.
I'm so pleased to teach me about the solution.
Thank you.
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...
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.)
Thank you LisaL. It worked! I appreciate your help.