I have a source file and target file(input file is a delimited file). I have to compare source and target file .Input source file example:
Input target file example:
Mapping Logic like that:
After that output file is like that only:
Now i want to split/filter/break above output in three sheet as:
(1) Passed Columns – In this sheet, populate the columns for which all the records have 100% match. Eg: Date and Name matches for all the rows.
(2) Failed Columns – In this sheet, populate the columns for which all the records have 100% mismatch. Eg: State has mismatches for all the rows.
(3) To be Investigated Columns – This sheet holds the columns where we have mixed records for rows. (for reference SAL_STATUS column.)
I want a automated job design for this.As i am a newbie for TOS-DI.Kindly help me in this.
Thanks in advance.