Skip to main content

What is the best approach to write to selected excel cells if I am overwriting using an existing template?

 

How can I make FME understand to apply the formula or the predefined values based on the feature count in my input file ? 

 

The template contains the predefined value in the first row. 

Item ID Program Full Name Master Certificate Number Address
  Dentist Association   XL89  
         
         

 

My Input File / Reader File

Item ID Full Name Address
12 Jon Doe 14 King St
45 Mary Jane 5 Todds Ave
345 Henry Smith 7 Queen St

 

My expected Output 

Item ID Program Full Name Master Certificate Number Address
12 Dentist Association Jon Doe XL89 14 King St
45 Dentist Association Mary Jane XL89 5 Todds Ave
345 Dentist Association Henry Smith XL89 7 Queen St

FeatureMerger

  • Input file = requestors.
  • Template = suppliers.
  • FeatureMerger setting 1 = 1. This will merge the supplier to all requestors.

Reply