HI,
I encountered this error on linq datatable even I converted the columns already
this is the linq code
linq code.txt (2.0 KB)
Properties of change data type
I also tried using column index / column name both not working
Hi @joscares ,
Could you let us know what are you trying to perform ?
If you could provide a Sample Input Data and it’s Expected Output in an Excel, we would have a more clear understanding of what needs to be done, along with a brief explanation of the logic you’re applying to get the output.
It seems the Linq code can be simplified, the error currently is happening due to the assignment of creditAmount with “N/A6” and an Attempt to convert this to a Double type in the later lines of code. As this is clearly not possible, we would want to understand what would you actually need to perform.
Hi @joscares
The error is because you are triying to convert N/A6 to Double
So correct there and enter proper value for convertion
Regards
Sudharsan