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 |