Hi @pat dev ,
1.Could you please share the example data in your flat file and DB-table and your desired output?
2.We can use Lookup Transformation to find the Match Data and NoMatch Data between flat file and DB-table.
3.May I know if you want to load Match Data or NoMatch Data from flat file to DB-table?
Please refer to the following pictures:
Best regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.