Solved

Data format issues when loading CSV

  • 21 June 2023
  • 2 replies
  • 52 views

Badge

Hi all,

We are trying to load CSV files into the ODX using the CSV data source. However we are getting errors on fields it is trying to interpret as int (housenumber), but some are filled in as 12-18 and therefor failing. We have tried to use the override data type option, but to no avail. What can we do about this?

Kind regards,
Maarten

icon

Best answer by rory.smith 21 June 2023, 14:27

View original

2 replies

Userlevel 5
Badge +7

Hi @Bitmetric_Maarten ,

you should use .rsd files to define such fields as string and then apply transformations to resolve those cases. This article gives you the basics: 

 

Badge

Thanks. This answer worked!

Reply