Specified cast is not valid while create a Datatable variable

Learning Hub
, ,
1

Hi everyone,

I am getting this error during this activity I use to split a table into multiple tables.

image
image1316×240 40.8 KB

I think i am getting this error because of variable types. Because when i convert this variables string to number on Excel; it solved.

But i don’t know where should i change at my code.

Here is assign code:

image
image1004×240 35.8 KB

2

Or anyone who know how may i solve this problem? how may i convert its data type to number? Then i think it will be solved.

@Palaniyappan

image
image820×164 34.5 KB

1 Like
3

Hi
In your group by function did we try mention as
Function(x) x.Field(of String)(“Siparis No”)

(Of Double) can’t be used unless that column is a double or numerical type

Cheers @mazlumkacar