Sequencing Export and Import jobs in Connect

Hello,

We are currently in the set up stage and started creating connect jobs to manage file imports.

I can see there are Group Jobs but the only allow for IMPORT sequencing and I am wondering how can both job types be linked to work one after the other?

For example, a process we have is:

1. Import into a supplemental table
2. SQL Join to extract RIID
3. export sql view
4. Import into a PET for future filters and Program use

Would love to hear other idea of what would be a better approach if not possible with CONNECT

Thank you!