How to filter excel file output in a three different sheet?

Six Stars

How to filter excel file output in a three different sheet?

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:

ID,NAME,STATE,SAL
101,PeterDuck,AC,90000
102,JohnBrett,JN,60000
103,WatsonLore,AL,75500
104,DumberRoll,SW,60000
105,JohnSnow,NK,100000

 

Input target file example:

101,PeterDuck,CA,90000
102,JohnBrett,NJ,60000
103,WatsonLore,LA,85500
106,LuciaSanon,KW,60000
107,Sersie,DQ,25000

inputFileReadwithtMapFilterLogic.png

 

 

Mapping Logic like that:tMapLogic.png

After that output file is like that only:

 

 

outPutExcelFile.png

 

 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.passedColumn.png

 

 

 

(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.FailedColumn.png

 

 

 

(3) To be Investigated  Columns – This sheet holds the columns where we have mixed records for rows.  (for reference SAL_STATUS column.)TBD.png

 

 

 

I want a automated job design for this.As  i am a newbie for TOS-DI.Kindly help me in this.

Thanks in advance.