I tried to find out in the forum but was not able to find anything which can be used to fulfill my requirement.
I have two files: File1 - 80 Byte and File2- 80 Byte
Key used for join key is:
Output that I am looking for is:
IF MATCHED the record should be picked from File1, IF NOT MATCHED the record should be picked from File2.
ABCDEF 12345 -----> From File1
LANOPD 23568 -----> From File2
would you please suggest/guide me to get this done?