on 10-02-2008 1:58 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you.
The lenght was the error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.