Default value for Foreign key field

[djugal]

Hi,

I have a data model of two entities

Student(ID, Name, CountryID)  Countries(ID, Name)

Now I have a data for Countries entity which is 0 - No Country Selected

How do I apply the same to my data model for the column Student / CountryID

I have tried with default value rule as [0] but still comes empty. Cant specify string here as "No Country Selected"

[Anonymous]

Hello @djugal，

Are you trying to validate patterns? Could you please give us more detailed steps to reproduce your issue? On which talend MDM build version you got that?

Best regards

Sabrina