Sorting error

Help
,
1

hey guys im trying to sort a column on a csv file base on date, but i always get this error

image
image585×230 9.48 KB

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
image213×204 3.92 KB

any help would be appreciated, thanks

2

Hi @RobertoEwaldo

Try this post:

Let know if this works for you

3

@RobertoEwaldo
can you please upload CSV?

4

will try it, thanks !

5

here csv 2.zip (1.6 KB)

6

@RobertoEwaldo
csv 2.zip (3.3 KB)

please check and let me know…

8

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

9

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

image
image1273×779 88.8 KB

11

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

image
image308×521 11.9 KB

12

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

13

@RobertoEwaldo

try this.
Sequence.xaml (6.6 KB)

regards
Aditya

14

it works, thanks !

15

@RobertoEwaldo

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

17

@RobertoEwaldo

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

Regards,
Aditya