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

Anonymous — Fri, 27 Jul 2018 07:25:46 GMT

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

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.

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