When i tried to write the data in the append range activity, I got Arithmetic Operation resulted in an overflow exception. Please help me to resolve this error.
I have used below query to remove the duplicate rows from Datatable.
(From r In Claim_Details_DT
Group By Distinct = New With {Key .Check_No = CInt(r(“Check_No”)), Key .Claim_No = CInt(r(“Claim_No”)), Key .MOS_No = CStr(r(“MOS_No”))} Into Group
Where Group.Count = 1
From g In Group
Select g
).CopyToDatatable
Maybe you want to change those Cint to CDbl, if your numbers are too big to fit that…
2 Likes
@bcorrea thank you