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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema