Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
First I want to say thank you for always helping me out, this community is very responsive and helpful!
I want to know if it's possible to create dynamic lookup queries for each row from main input query
Let's say i have this structure:
Salesforce INPUT (lookup)
|
SQLInput (5 rows) > tmap > salesforceOUTPUT
for the Salesforce INPUT lookup, i want to set the query to only select based on a value for each row from the SQLinput.
That way it doens't have to select all the records then do a lookup which can slow things down
Thank you!!
@Zykros , You may try with reload for each row option in tmap to get the specific record lookup.