Capture File Name and put into a separate Database Table only once.

[Anonymous]

I am very new to Talend.  I've been an SSIS dev for 3 years.  I am creating a "Files Loaded" table so we can see what has been loaded and also use it to reference and not process the same file twice, if I happened to get resent. (dealing with government entity so you never know.) 

I was able to branch off of the tMap1 and insert into my table however it was inserting a file name per row of the table instead of just inserting the name once. The table structure I'm inserting into is as follows:

Any advice?

[Anonymous · Accepted solution]

An easy way of doing this is to restrict the data after the tMap1. Place a tAggregateRow component after the tMap1 and connect the output of that to the Files Loaded component. Do not add a group by element for this component, but set all of your output column functions to First or Last. This will group your entire set into 1 row.

[Anonymous]

Perfect!!! Thanks.  Worked like a charm.  Now on to getting the record counts input into the table.