AnsweredAssumed Answered

Getting unmatched records and matched

Question asked by ranjith.martha569090 on Oct 12, 2017
Latest reply on Oct 12, 2017 by leif_jacobsen

I am trying to achive below, but has few hiccups;

Source has Data as below:

Source File:
CUSTID|CUST_ALT_ID|CUSTNAME
101|1|DEN
102|2|CRAY
108|8|LUS


Database
VNDR_ID| CUSTID|CUST_ALT_ID
10|101|1
11|102|2
12|103|3
13|104|4
14|105|5

Expected Output that needs to be loaded in new Table:
VNDR_ID| CUSTID|CUST_ALT_ID|DOB
10|101|1|1999-12-31
11|102|2|1999-12-30


Exceptions for Unmatched w.r.r the CUST First Source File:
EXC_ID|REASON|CUSTID
1|NOT MATCH|108

Outcomes