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.
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