Can you please explain how to upsert data from excel file to salesforce. The salesforce object has no lookup field. Just need to upsert on single object with an external custom/standard field. How to design talend job for this case?
Solved! Go to Solution.
I done it like TFileInputExcel ==> tMap ==> tSalesforceOutput(External Id).
It is upserting data correctly into salesforce. Thanks for reply.
But after executing talend job, giving exception: java.io.IOException: Name not specified - here Name is standard field (Upsert key column).
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Move from On-Premises to the Cloud by following the advice of experts
Learn about modern data engineering in the Cloud
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries