Salesforce Lookup Trouble

[MGowan]

I'm new to Talend and having some trouble. I'm pulling data from an AS400 and pushing it to a Salesforce custom object (currently a test file). That part is working fine, but I'm trying to add a lookup that will pull the Salesforce ID for the related account to the custom object. Can this be done in a single job or do I need to add a subjob?

[Anonymous]

Yes, you can query the account information including the account ID from salesforce and do a lookup. From your screenshot, I see tSalesforceInput returns 0 rows, do you add any conditions in the query? If so, can you show us the query condition?

[MGowan]

I was able to get it working. I simplified the job, removed the custom query on the lookup, and it started working.