Skip to main content
Question

Schema Mapping with Attributes and fme_data_type

  • November 24, 2015
  • 1 reply
  • 59 views

Forum|alt.badge.img+1
Hi,

 

 

I have an excel spreadsheet with the following three columns:

 

 

ORIGINAL_FIELD_NAME

 

NEW_FIELD_NAME

 

FME_DATA_TYPE (populated with "number", "varchar2", etc)

 

 

I want to write to a Dynamic Writer that automatically updates the field names and populates the "Name" and "Type" with the information from the excel spreadsheet.

 

 

I have worked out how to use the "SchemaMapper" transformer to update the field names, but how do I use these tools to automatically populate the "Type" field in the writer?

 

 

I am writing to Oracle and using FME Desktop 2015.

 

 

Thanks

 

 

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.

1 reply

david_r
Celebrity
  • November 24, 2015
Hi

 

 

Have a look at this article.

 

 

David