Skip to main content
Solved

manual attribute type definition in CSV reader (FME v2022.1)


Forum|alt.badge.img

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

Best answer by nielsgerrits

you can use a Creator to initiate the FeatureReader.

View original
Did this help you find an answer to your question?

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • June 6, 2023

you can use a Creator to initiate the FeatureReader.


Forum|alt.badge.img
  • Author
  • June 30, 2023

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


nielsgerrits
VIP
Forum|alt.badge.img+54
mzuer wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings