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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now