Error encountered on unmatched linq: Conversion from string "N/A6" to type 'Double' is not valid

HI,

I encountered this error on linq datatable even I converted the columns already

image

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