topic Re: Create a drop down list field with Talend MDM in Talend Data Catalog

Create a drop down list field with Talend MDM

Anonymous — Fri, 08 Dec 2017 11:00:09 GMT

Hello everybody,

I work on Talend Open Studio for MDM and I wish to create a field drop-down list among the fields of a table. I want that the values of this drop-down list come from a distant MSSQL database, or from any other resources.

On all the forums that I browsed, it is possible to make it by linking entities between them with a foreign key. However, the valuable list appears in a tab instead of a drop-down list as I wish it (not very practical for the user)

Can you help me please?

Thank you in advance for your answers

Re: Create a drop down list field with Talend MDM

Anonymous — Tue, 19 Dec 2017 06:41:44 GMT

Hello,

@powerMDM wrote:

Hello everybody,

I work on Talend Open Studio for MDM and I wish to create a field drop-down list among the fields of a table. I want that the values of this drop-down list come from a distant MSSQL database, or from any other resources.

On all the forums that I browsed, it is possible to make it by linking entities between them with a foreign key. However, the valuable list appears in a tab instead of a drop-down list as I wish it (not very practical for the user)

Can you help me please?

Thank you in advance for your answers

Sorry for delay!

You need set the Data Model Types as enumeration.

Please have a look at this online document about:TalendHelpCenteretting up a data model for details

Best regards

Sabrina

Re: Create a drop down list field with Talend MDM

Anonymous — Fri, 22 Dec 2017 08:59:57 GMT

Hi Sabrina,

Thanks you for your answer but I have already created my data model with a field drop down list as you suggest.

Now, I want to have the same result with a table outside the datamodel.

For example, imagine I have a table based on a list of town with a field area. I want that my field area will be a drop down list from a table area in a MSSQL database.

Is there any possibility to have this result ?

Much thanks

Best regards

powerMDM