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. 

for desired output table:

for only matched values between the paid_to_pt_sys_no,portfo_sys_no fileds i need get portfoilo_number and for rest i need shown "UNKNOW" . As shown below 

 

ACCT_NUMBERPORTFOLIO_SYS_NOACCT_PAID_TO_R
11000600445174110006004.2
11048460720856110484607.2
11038630710106UNKNOW
11038630710155UNKNOW
110458601819UNKNOW

 

Thanks,

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      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 ..

    • Anonymous's avatar
      Anonymous
      Not applicable

      all the three tables are mapped to primary key ..