Skip to main content
  • EN

I would like to output an excel template with one of the columns having cells containing values from a pick list. 

 

From my understanding I don't think FME is able to output the picklist, but a possible solution is to have the pick list already defined in the excel template.

 

However, even if I have the cell defined, I do not know how to have it replicated for each row that is outputted from the FME template. Do I have to just fill the entire column with the picklist and than delete the extra rows after the fme template is run or is there a more elegant solution.

 

Thanks

for your template, if you follow the following guide, you can create a dynamic picklist.

https://www.excelcampus.com/tips/dynamic-data-validation/

 

Then in FME you'll need to update the table/column with the new values you need in your picklist

Reply


Community Stats

30,120
Posts
114,319
Replies
37,748
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.