I have two data files with similar columns and I am looking for a join, filter or reformat component that can help me read the records from the first data file which are not in the second file. I have been able to do this with ExtHashJoin and ExFilter components but I am thinking about a less heavy way.
Any helps is appreciated.
Have you considered trying a DataIntersection component?
That would be where I would start. You specify what you want to "match" between your two files and the component shows you how they intersect. This component has two inputs (in your face file1 and file2) and three outputs (records only in file1, records in both, records only in file2). You would want to tie to output port 1.