Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Populating hard coded values for unmatched values between the fields

Populating hard coded values for unmatched values between the fields .   For example: Below is the table there are values for  Acct_number, portfoilo_number, paid_to_pt_sys_no,portfo_sys_no.  ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Column

if(paid_to_pt_sys_no=portfo_sys_no,portfo_no&"","UNKNOWN")
Anonymous's avatar
Anonymous
Not applicable
6 years ago

all the three tables are mapped to primary key ..