I wanted to create a data naming tool in FME, essentially I have a list of values (currently in a SharePoint list but could feasibly be moved to a SQL Server table if required). For each section of my data naming tool I want to look up the user friendly term in my table using a drop down list control in FME (e.g. Look up the value "United Kingdom") and return the coded value (e.g. UNK). This would be done for 54 category items to create something like: "UNK_01_M2_SE_HealthCentres_20140529.shp”
The first four items are the returned coded values for the drop down list items, the text in the middle (HealthCentres) is a free text field, and finally the date is system generated. The sticking point I have is that the values the user chooses from the drop down list must be dynamic as this list will constantly be updated.
Does it sound feasible? If so what transformers would get me on the right track?
Regards,
Kevin