Skip to Content
0
Dec 20, 2018 at 02:26 PM

Two table Comparison to generate a Complete file and an Error file

85 Views

I have an Output Table (Table 1) with 1.8M records. I have another table that has Cost Centers (CC Table). I need to compare Table 1 to CC table for Cost Centers (field) that don't exist in Table 1 then generate two tables: an Error Output table and an Output Table (Table 2). Table 1 is constructed by 32 source Excel and BODS files/tables combined with a Merge Transform. I'm not sure where to put the CC Table and how to connect it to perform the task. Any suggestions would be a lifesaver. Thank you.