Assignment

[Former Member]

MDM Experts,

I am new to MDM. I need to create a assignment. The rerquirement is

If field "A" is empty and field "B" is empty, then copy value of field "C" in to field "B", If field "A" and field "B" are not empty then keep the value of field "B".

These are all Main table records.

I tried this and did not work.

IF(IS_NULL(A AND B), C, B)

And table field = B

thank you

Dan

[Former Member · Accepted solution]

Hi Dan,

your assignment works fine with me. Where did you get the error? When you close the assignment editor or when you execute the assignment? Make sure that you use the drop-down menus in assignment editor to create your expression. Also make sue that all fields are text or integer fields.

Christian

[Former Member · Accepted solution]

Hi,

Thanks for your input.

All fields are Text fields. The error occurs when I execute the Assignment.

If I use string instead of field then it works fine. For example

IF(IS_NULL(A AND B), "Success", B)

Regards,

Dan

[Former Member · Accepted solution]

Could it be the length of the field, that the content of C does not fit into B? Could you create a test assignment that simply contains "C" and the target field as B to test it?

Christian

[Former Member · Accepted solution]

Hi,

If I use following expression, it works.

IF(Is_Null(A) AND Is_Null(B), C, B).

Thank you for your help.

DAN

[Former Member]

thanks

[Former Member]

Thanks

[Former Member]

Thank you

[Former Member]

Thank you.

The lenght was the error.