Forum Discussion
Anonymous
6 years agoNot applicable
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_NUMBER | PORTFOLIO_SYS_NO | ACCT_PAID_TO_R |
| 110006004 | 45174 | 110006004.2 |
| 110484607 | 20856 | 110484607.2 |
| 110386307 | 10106 | UNKNOW |
| 110386307 | 10155 | UNKNOW |
| 110458601 | 819 | UNKNOW |
Thanks,
3 Replies
- amitchandakSuper User
Column
if(paid_to_pt_sys_no=portfo_sys_no,portfo_no&"","UNKNOWN")
- AnonymousNot 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 ..
- AnonymousNot applicable
all the three tables are mapped to primary key ..