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