Default value population

[Former Member]

Hi Folks,

When you create a record in the data manager - all the fields of that new record have nothing in them ... they have tobe entered or selected. This looks nomal ... now look at this ... We have a situation ... where a value defaults itself, without any rhyme or reason.

This is happening with only one field and it doesn't go away if its mapped as "null" during import !!

Any .. insights !! ?

Regards,

Vinay

[former_member205403]

Hi Vinay,

Another option is also available.

you can use <b>assignment</b> to assign a default value to any field in place of null value.

Suppose i am having a field country,and it is containing <b>null</b> then i can use an assignment to define the default value .The assignment expression will be like this

<b>IF(IS_NULL(COUNTRY),INDIA,COUNTRY)</b>

now run this assignment.The above expression will replace all null values with default value "INDIA".If the field country is having some other value then that will not be changed.

Hope it will solve your problem.

Thanks,

Shiv Prashant Dixit

[Former Member]

Check the settings for the paticular field in MDM Console.

If the Type is Boolean, you can set <b>Default Value</b> in the Console.

So, if there is no value during the import or during data maintainence in Data Manager, the value of that field is defaulted to the value provided in Console.

[Former Member]

Hi Vinay

What kind of value do you get in the data manager for that particular field?

Vinod