Question

New Attributes Added to Source Dataset

  • 6 November 2017
  • 2 replies
  • 1 view

Is there a way in FME to detect if there has been a change in the attributes name or if there has been a new added attribute to a source file how it can be synchonised in writer


2 replies

Userlevel 2
Badge +12

If you have a copy of the original source file, you can use the "Schema reader (any schema)" to read the schema of original and new source file.

The use the ChangeDetector transformer to find any changes in source schema.

Userlevel 4
Badge +25

You can use Readers > Update Feature Types to refresh the source data feature types.

There is a Writers > Update Feature Types too, but that's not so useful if the output isn't a database table that already exists. Instead, maybe have the writer feature type attributes set to Automatic, so that any change in the reader also updates the writer.

Here's a quick movie to show how it is done: https://www.screencast.com/t/Zpb56FfJzo

Reply