Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.