Hi all, I am beginner on Talend. i created a standard job for importing data into Salesforce using upsert.
I want to make a lookup on the table RecordType to get the id corresponding to the type of my input stream ex: type = "physical person" I want to retrieve the corresponding id, in other words I want the id corresponding to type = RecordType.Name.
I'm using the tSalesforceOutput i know that i can do this in advanced settings,
if possible i don't want to make it with tMap and tSalesforceInput. what should I put in the columns so that I can do my lookup.
Tanks in advance
Column name of Talend Schema : Input column
Lookup Filed Name : lookup filed type
Module name:- the Object which you were doing lookup
Exteral id name:- Id filed from the Lookup Modudule.
please check below link.
@sandbox_talend,did it help you?
Hello, sorry I was a little busy, I found another solution is to do it in two stages, I have not yet managed to do it but I'm on the way thank you.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.