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
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?