Generate Data Table - wrong data type

[jaxng]

Hi all,

I’m facing an issue converting text to data table. Most of my fields are in decimals. e.g 0.00.

However, the tool read it as 0 and set as integer.

When I do a table merge, it will throw an error on the data type invalid.

Anyone encounter this before and has a solution or workaround? Is it possible to change the column type of an existing datatable ? Thank you.

*I’m using c#

[Yoichi]

Hi,

It seems limitation of auto detect.
As workaround, how about the following?

1. Add text record including dummy decimal data such as 1.23 into the text

2. Generate DataTable

3. Remove the final row

Regards,

[jaxng]

Thanks! This worked for me.