One Star

Download specific files from FTP that don't exist in Salesforce

Hi,
I am trying to build a process that download files from a FTP that don't exist in Salesforce, and those which don't exist, load them in Salesforce. I am having problems to get the files that don't exist in Salesforce.
This is the process that i have
Any help will be appreciated.
3 REPLIES
Four Stars

Re: Download specific files from FTP that don't exist in Salesforce

Hi,
From screenshot it seems that you are implementing a join(not sure which) to get the list of files from ftp that don't exists salesforce and again load them in salesforce. If this is correct
- Implement InnerJoin in tMap with FTP files list as main and SalesForce as lookup
- Get InnerJoinReject from tMap output - This will give you list of files which are not avaiable in SalesForce
- Iterate on each file to load into SalesForce
Check one of the useful post - http://www.talendforge.org/forum/viewtopic.php?pid=23969#p23969
Vaibhav
One Star

Re: Download specific files from FTP that don't exist in Salesforce

Thank you for your solution. It really helped!
Moderator

Re: Download specific files from FTP that don't exist in Salesforce

Hi sbravo,
Would you mind marking your post as "resolved" so that other users can identify it.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.