Large data file with decimal value error

[im-saboor]

I have large number of columns consist of volumes and text along with dates. 

Any quick solution to solve this decimal error. Thank you for your help!

[Zanqueta]

Hi @im-saboor 

A simple approach is to identify the problematic column and assign the correct data type, or use a safer conversion with try ... otherwise so that a single invalid value does not cause the entire query to fail.

try Number.From([ColumnName]) otherwise null

For large datasets, I would also check whether some columns containing identifiers, invoice numbers, barcodes, or account numbers should be stored as Text rather than Decimal Number.