Yes I want two files one with bad data and one with good. The problem is the files with bad data could have other records that are good but would need to be pulled out also based on a unique column. The column could contain multiple records with only some of them being bad but all needing to be removed.

Sorry I should have been more clear.