Use values from database as LOVs for context prompts

[nivedhitha]

Hi,

I have a situation where i have to get distinct project names from a table in database and use a prompt to get the name of the project the incoming file is related to from the user and load the input project name into the target table.

Does anyone have any suggestions/ideas for me?

Any input is appreciated. Thanks in advance.

[akumar2301 · Accepted solution]

https://community.talend.com/t5/Design-and-Development/Dynamic-list-in-dropdown/m-p/87994#M47469

https://help.talend.com/reader/xVLugMXF_5tB0A02HbPaNw/yccVLSPFaROR4TA94_rUFw

[nivedhitha]

Exactly what I needed.

thanks much