Hi All,
I have an assignment expression created with the field "Name" which if is null ie no value at all,then should load a default value from the lookup table
I have the assignment defined as follows
If(Is_Null(Name),Name[3])
where Name[3] is a value from a lookup table.
When i execute the above assignment it fails as "Assignment Operation failed. I tried with "If then else " statement as follows and it too fails when i execute the assignment
If(Is_Null(Name),Name[3],Name)
where Name[3] is a value from a lookup table.
Any Help greatly appreciated
Thanks,
Aravind