Need paired and unpaired record in a same file.
Posted: Wed Dec 23, 2015 5:36 pm
Hi ,
I have a requirement where i will be matching 2 files with a key and pull the matched record along with other columns from file2 . see below for example.
File1 is primary, file1 will be compared with file 2 and pull the matched records and write an output in formatted way (123,456,A,) also i need unmatched record from file1 to output with space in the last byte like (234,567, ,)
I tried file joining but couldn't able to get the result. Kindly help to provide the sort card for this.
File 1
123456
234567
File2
123456XXXXXXA
534556xxxxxxZ
Expected output
--------------------------
123,456,A,
234,567, ,
I have a requirement where i will be matching 2 files with a key and pull the matched record along with other columns from file2 . see below for example.
File1 is primary, file1 will be compared with file 2 and pull the matched records and write an output in formatted way (123,456,A,) also i need unmatched record from file1 to output with space in the last byte like (234,567, ,)
I tried file joining but couldn't able to get the result. Kindly help to provide the sort card for this.
File 1
123456
234567
File2
123456XXXXXXA
534556xxxxxxZ
Expected output
--------------------------
123,456,A,
234,567, ,