Skip to main content
  • EN

I'm given a location of files. I'm using the directory and files reader to get all the files in that directory. I then use the featureReader to get only the csv files. There are 181 attributes so instead of exposing them, I'm specifying a feature type to read. The csv files all have the same attributes, just in different orders. For instance one file could have attribute1,attribute2,attribute3 and another file would have attribute2,attribute1,attribute3. I'm using attributeManager to calculate some values and because all the files have the same attributes, I just used the order of the first csv so the order of the attributes leaving attributeManager is always attribute2,attribute1,attribute3.

I am writing out csv based on the name from the path_rootname (to a different folder). The issue is that I need the output files to retain the same attribute order as the input csv. Because all features enter the AttributeManager, they all come out with the order from that transformer. I was reading about dynamic schema and that I could use the schema from the featureReader to specify the order. This works except the schema port of the FeatureReader only showed 1 schema (the first csv). It also only has the file name of the first csv so when I do a featureMerger, I'm only getting records for that csv. Not sure what I'm doing wrong.

@tnarladni

Indeed make a schema from the csv whose schema you want ot use prior to using the feature reader.

There are many (repeats) of the way to make the scema on the forum.

If I've understood correctly, you want to maintain a different schema for each file. In the featurereader under the csv parameters, ensure the Feature Type Name is set to From File Name(s) not from Format Name. You should then get multiple schema features from the schema port one for each feature type.

 

 

If I've understood correctly, you want to maintain a different schema for each file. In the featurereader under the csv parameters, ensure the Feature Type Name is set to From File Name(s) not from Format Name. You should then get multiple schema features from the schema port one for each feature type.

 

 

Thanks @egomm! That was it.

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

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.