Sort column from newest to largest

Help Studio
, ,
1

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
2

Hey @RPA_Path

Try with any of the below activites,

Thanks
#nK

3

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.

4

@RPA_Path Please find the below workflow

Example.zip (9.2 KB)

please find the output below

Capture

5

@RPA_Path Enable preserve format in Read Range

Capture
Capture956×336 16 KB

7

@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)

8

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

1 Like
9

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
10

Hey @RPA_Path

You need to remove zero from the datatable rows right ?

Thanks
#nK

11

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