I want to Create a choice User Parameter that will show column list details from database, This will enable me to select my choice column field that when I run the workflow, I will be able to get the output result for only the column in a fanout dataset.
When creating a choice User parameter type, the only option is a static “Import from dataset” to populate the choices. This needs you to update FME workspace, returning to the user parameter if the database lookup change / get new values and import it again (over the top).
The only other way I can think of is….to do this is with User parameter attribute name, do not disable attribute assignment
You need this User Parameter assigned to a reader that is connected to the Database and table. See description below. There’s a fair bit of complexity in this option
Hi
I am really curious about the second method you suggested. Using Attribute Name type in User Parameters.
I did a bit of digging and found some more information:
But I still cannot wrap my head around how this should work. Can you expand? In just “trying things out” I did get a result by assigning the Parameter to the Generic Port but I am missing the bigger picture here on this functionality. Any ideas you could share would be awesome and thanks!
