Change Format and borders

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.

Workflow

Output

Date Time

Help

Accepted answers

grazitti_sapna

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_workflow.yxmd

All comments

binu_acs

@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

MonthFormat_06_06.yxmd

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.

dateformat_sort.yxmd

grazitti_sapna

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_workflow.yxmd

neromerob

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703