Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I'm assigned to create a job, however I've never done anything with FTP nor XML components before. (only SQL and retreive/update DB)
The documentation can only show me as much as the general info, but I haven't seen anything that can help me further with where I'm stuck on.
My mentor is unfortunately unavailable and I hoped that someone could get me started here /steer me in the right direction.
I've broken down the job as per below what needs to be done.
The Job;
Up to now I have below schedule created;
Many thanks in advance for your help!
This is not the best way to ask a question here I am afraid. You have essentially asked for a complete solution which is made up of multiple problems. You will need to first solve the FTP part of this and then go to the XML processing part.
To start you off, if you want to find check whether the files exist, you will need to first use the tFTPFileList component. This will allow you to carry out a search of your FTP location for certain file patterns. It will return the records via an Iterate flow, so you'll probably want to use a tIterateToFlow component to work with this data.
Have a look at this example (https://help.talend.com/r/en-US/7.3/ftp/tftpfilelist-tftpconnection-tlogrow-listing-and-getting-files-folders-on-ftp-directory-standard-component) which shows this in a very simple way. Then try and extrapolate from this to get to solving the first part of your issue.