Skip to main content
Solved

FeatureMerger query

  • February 4, 2015
  • 4 replies
  • 33 views
J
Hello,

 

I have 2 csv first CSV with Id and other csv with ID plus additional attributes. My aim is to get geometry from Oracle Spatial based on IDs from first CSV using featureReader and then use featureMerger to add addinal attributes from 2nd csv (joining on ID). For some reasons I am not able to write to destination writer. I have created a schema file for writer. I am getting an error as "no schema defined for feature .... " for FeatureReader.

 

 

what I am doing wrong here?

 

Cheers

 

John

Best answer by gio

Create a schema wich is a combination of the schema from the columns of the oracle table(s) you read and the additional attributes.

 

Then you should have covered all attributes.

 

 
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • Best Answer
  • February 4, 2015
Create a schema wich is a combination of the schema from the columns of the oracle table(s) you read and the additional attributes.

 

Then you should have covered all attributes.

 

 
takashi
Celebrity
  • takashiCelebrity
  • February 5, 2015
Hi John,

 

 

I don't think the FeatureReader requires a specific schema definition in general.

 

Could you please paste error messages shown on the Log window?

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • February 5, 2015
I don't think he needs the schema when using a feature reader as well.

 

But if he does use a schema derived form the tables read by the featurereader and then adds extra attributes, then i gather that the extra attributes are not in the schema. Hence the error.

 

 

Thats why i suggested, if using a schema with the writer, to combine the new attributes with the schema from the tables.
takashi
Celebrity
  • takashiCelebrity
  • February 5, 2015
I guess he created a look-up table for the dynamic writer feature type, since he said "I have created a schema file for writer". And I'm wondering whether the feature type name defined in the table matches with actual feature type name to be written.

 

Anyway, cannot specify the reason unless seeing the error log.
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.