Hello everyone!
This might be really simple but I'm unable to solve it. I have a workflow where I need to Split the rows and group them by Month. The initial data looks like this:
And I would like to make it look like this:
I have managed somehow to do this using Basic table and Render to export it in excel but I need to do it somehow without using basic table(as after this I need to edit the data again using Preparation and Join Tools. Is there any way to do it?
Thank you for the assistance!
Solved! Go to Solution.
Hello @AndrGVR ,
I gave it a whirl. The data is not exactly the same as your . However the logic is there and should give you an idea.
Hope you find it helpful.
@ImadZidan 's solution is a good way to force the data set if you're pushing out to CSV.
If you want this to remain in Alteryx - you can just create a month field (YYYYMM) and then use this in many of the tools to do grouping - for example, the basic table tool can use a grouping field.