topic Re: Capture File Name and put into a separate Database Table only once. in Talend Studio

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

Anonymous — Wed, 15 Aug 2018 16:31:30 GMT

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?

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

Anonymous — Wed, 15 Aug 2018 17:23:34 GMT

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.

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

Anonymous — Wed, 15 Aug 2018 18:18:25 GMT

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