Change Format and borders

[neromerob]

Hello to everyone 

I have been Working in a Workflow that produce and excel file with 3 tabs. that said the first that that i produce is somethin like this. I change de date with a dynamic replace tool

But what they want is the data to be shown like this 

Don´t know is this is even doable in Alteryx but what i need is. 

• Dates that could appear in order and not alphabetical order. 
• The borders in every new records considering that is dynamic information and new month will always be added.

Thank you. 

[binuacs]

@neromerob Im  not sure I understand your requirement properly. Based on my understanding you can write a formula like below to achieve this. Please provide a sample input and expected output file if the given solution is not what you are looking for

[CathyS_Slalom]

Hi @neromerob, if you want to re-format the date, you can use the DateTime tool below to convert the format.

First DateTime configuration:

Second DateTime Configuration:

[neromerob]

hello to everyone. 

First, thank you for your help, I used the formula that you told me but the info appears in alphabetical order, which is incorrect. consider that I´m working to order the information from a workflow an not from a table. 

[CathyS_Slalom]

Hi @neromerob, to sort the data by the date order, you can add the sort tool after the first DateTime tool, and sort on the DateTime_Out column. Then use the select tool at the end to only select the formatted column.

[CathyS_Slalom]

Here is the workflow for your convenience.

[neromerob]

I decided to work with the original format of the date to understand how I can change it .

still i can get the date the way i want, and also because I have 2 April months, the system show it like this 

April-2021

April-2022

Instead of April-2021 and May-2021

[grazitti_sapna · Accepted solution]

Hi @neromerob , when you reach to the below step 

Try using the record id tool

Then do the date transformations in case you still find it unsorted then you can simply sort the data on the basis of the record id tool ascending it will give you the expected output.

The final result can be achieved using reporting tools.

I hope this helps!

Thanks!

[neromerob]

Thank you to all of you for the help. Solution found.