Sorting error

Build
#1

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

#2

Hi @RobertoEwaldo

Try this post:

Let know if this works for you

1 Like
#3

@RobertoEwaldo
can you please upload CSV?

#4

will try it, thanks !

1 Like
#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
image.png1273×779 88.8 KB

#11

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

image
image.png308×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

#18

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