topic Re: Check the mask file by comparing it's name with a table in Talend Studio

Check the mask file by comparing it's name with a table

elkhansaa — Sat, 16 Nov 2024 01:02:14 GMT

Hello

I browse a file list (from sftp) to integrate it into a table. I want to check the file if it has already been loaded by comparing its name with a table that contains the list of all the files loaded

How i do it please

Thanks

Re: Check the mask file by comparing it's name with a table

Anonymous — Sat, 28 Nov 2020 23:24:22 GMT

Do you already have a base for this job? By that I mean, are you already able to collect a list of file names from your sftp location? If you are, can you post a screenshot and we can talk you through the next steps.

Otherwise, you need to first use a tFTPFileList component. Follow this mini tutorial to get started (https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/2Bh7tJbkdtVnEjl4Y4fuGA). Once you get to this point, let us know if you still have some questions. Try to send us a screenshot of your job when you do.

Re: Check the mask file by comparing it's name with a table

elkhansaa — Mon, 30 Nov 2020 08:50:40 GMT

@rhall

I miss only loading the files have loaded before (those set in a table) cad add the filter that I don't know how i will do it

Thanks

Re: Check the mask file by comparing it's name with a table

elkhansaa — Mon, 30 Nov 2020 08:52:32 GMT