Sort column from newest to largest

Hi,

I am a column where I have date:
image

I’d like to sort it by newest to largest. For example,

4/10/2022
4/11/2022
4/12/2022…

1 Like

Hey @RPA_Path

Try with any of the below activites,

Thanks
#nK

Hi @Nithinkrishna ,

I tried with this but it doesn’t work with the zero’s. If I remove the zero’s then it works. I tried to remove the zero’s from the column but was unable to.

@RPA_Path Please find the below workflow

Example.zip (9.2 KB)

please find the output below

Capture

@RPA_Path Enable preserve format in Read Range

I read my data table from a .csv

@RPA_Path I am not getting any 0’s while reading from the CSV. can you share the sample CSV that you have

Please find the updated workflow

Example.zip (2.3 KB)

I believe once you append to the already existing datatable/excel file it adds the 0s.

1 Like

Once I append it to an excel file after reading it from a csv file, it writes the data table from .csv file as text

1 Like

Hey @RPA_Path

You need to remove zero from the datatable rows right ?

Thanks
#nK

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.