Skip to main content
  • EN

Dear all,

I am using a CSV reader to read my data from csv file. I have a column that contains almost only integer except 5 values, that contain a letter (e.g. 12a or 12b). Unfortunately the reader set the Type of this attribute to uint32, and the values that contain a letter are set to Null... So I loose this information...

It seems that in older versions of FME there was possible to choose "Manual" for "Attribute definition" parameter. But I doesn't see this option in the 2022.1 version of FME.

How could I do then to force this column to be read as a string ?

I've seen that it is possible to specify manually attribute types in the FeatureReader, but could I use this transformer to read a file ? (I set the file path in the parameter, but I don't know what to pass in input, and the output is empty)

 

Thanks in advance for any help

you can use a Creator to initiate the FeatureReader.

thanks ! it is what I did finally but was curious to know if it was possible to do it with the csv reader

thanks ! it is what I did finally but was curious to know if it was possible to do it with the csv reader

Cheers. I'm quite sure it can also be done in a classic CSV reader but since the FeatureReader was added I've never used a classic reader anymore, so I need to really look into it. Personally I prefer the Creator / FeatureReader over the classic reader as I find it more intuitive.

Reply


Community Stats

30,112
Posts
114,307
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.