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

Thanks for respone ..

 

Based the 3 tables , the input table has been build . Account_number from  account table, paid_to from transaction table, other two fields from portfolio table . it a direct mode .  Can you now help me on this ..