Sorting error

hey guys im trying to sort a column on a csv file base on date, but i always get this error
image
i tried using column dt.Columns(“column name”) , using index 1 (the second column), using column name as “column name” but no luck.

this is my workflow
image

any help would be appreciated, thanks

Hi @RobertoEwaldo

Try this post:

Let know if this works for you

1 Like

@RobertoEwaldo
can you please upload CSV?

will try it, thanks !

1 Like

here csv 2.zip (1.6 KB)

@RobertoEwaldo
csv 2.zip (3.3 KB)

please check and let me know…

it’s not error, but it’s not sorted
image

@RobertoEwaldo

it is sorted but in descending order as sort activity is set to “descending”.
just set to “ascending” to get data in ascending order.

look at row 15 & 16 and the months :grin:

i think it’s sorted based on the dates only @rahatadi

@RobertoEwaldo

try this.
Sequence.xaml (6.6 KB)

regards
Aditya

it works, thanks !

@RobertoEwaldo

no problem,
if you have any difficulties, feel free to ask me :slight_smile:

@RobertoEwaldo

dose provided workflow solved your issue? or still needs some changes ?

Regards,
Aditya

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