Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mcomstobe
Contributor
Contributor

Salesforce loading related objects with single output

I have talend job that works as designed, except that I need to create a parent-child relationship between the two custom objects and to do so i need the first custom object to load before the second custom object.

 

I have read a bunch of documentation, regarding the tFixedInputFlow, but because I need the output of the tmap for both tsalesforceoutput components I don't believe this will work.  I have also tried to use tSleep to pause the second/related custom object, so the first custom object can load completely and this did not work either.  

 

What am I missing?

 

 

I have attached a simple representation of the real job, and all I want to do is load the patient output completely, before the patient_encounter output.

 

Your help is greatly appreciated.

 

Labels (3)
10 Replies
TRF
Champion II
Champion II

Remove the tSleep and replace the Add_EhrEncounters by a tHashOutput.
Add a tHashInput connected to the tMSSQLInput by an onSubjobOk trigger.
Connect the Add_EhrEncounters to this tHashInput. Don't forget to refer the tHashOutput from the tHashInput and to to set the schema.