Finding UnMatched in LookUp

I have a data flow map that has an excel sheet as the source.....the sheet contains 200 records....My 1st goal is to find related records within my MySQL database.....so I created a SQL Statement Lookup Transformation.....WORKS GREAT!! I found 100% matches (200 excel records matching 200 mysql database records)....

However....within MySQL database I have 250 records......I know that out of the 250 records...I have 200 that match the 200 in the excel sheet.....What I Do Not Know is which 50 records are missing from the Excel sheet....how can I find which 50 are missing??? Is there a "Find UnMatched" transformation???

Thank You


Please sign in to leave a comment.