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