Schema Mapping with Attributes and fme_data_type

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