I want to make both these execute in a sequence, the tFileOutputExcel_1 in Job 1 is the where all the joins will take place, which is used in the 2nd Job to be associated with the lookup data from all the Master Files.
Can I put them in the same job and execute them in a sequence?
You can create a main job, and call these two child jobs using tRunJob, and control the execution order using Onsubjobok connector.
main job:
tRunJob1(call J_Import_Multiple_Files0.1)
|onsubjobok
tRunJob2(call J_Master_Files0.1)