Data type issue

CloverDX Platform
1

Hi,
I have been using UniversalDataReader to read a csv file which have a column price and this column contains value like 107.78. I need to transform this data into another format and saves into MS Access database.
for this I have created metadata which includes price field with “long” data type but on executing the graph I am receiving following error:
“Metadata on input port must not use field of type long because of restrictions of used driver.Convert the field to another type or use another matching field type.”

I have tried double and number data type but getting same error. Kindly let me know the way out to this error.

2

Hi gurdeep,

Long data type can not store such number, only decimal and number data types can do that in CloverETL. If you get this error using them, there is probably something wrong with your MS Access settings or with your driver. Which data type do you use in Access? And how would you like to transform this number in CloverETL?

Regards,