How to add query on top of a processed dataset

[jsaha]

Hi experts,

Kind of new in Alteryx and have a use case that I am trying to resolve for past hours and not able to do so.

I have two servers from where data is coming in with SQL, then i had a left join, filter and calculations to create a dataset (for example Table1) inside Alteryx. Now i have a big query that supposed to run on this Table1, will be too much to create all calculations in SQL i have, also has a long WHERE clause.  Any idea how i can achieve this?

Process now has been running with multiple staging tables in SQL server. and am trying to go away from those using Alteryx.

Any help in here?

thanks

[jrlindem]

What version of Alteryx are you running?  If you are 2023.1+ you can use Control Containers to run the initial data, then in the second joined container, call for that data and run the next part of your process.

I'm sure others will have ideas too, but that's a quick solution to ensure sequencing, that comes to mind.

-Jay

[jsaha]

Thanks Jay, version is 2023.2.

and yes, i have first steps in one container and SELECT is the last step in that container, but i am not sure how in my second container i can run a sql query on the data from 1st, any example would be nice. 

thanks

[jrlindem · Accepted solution]

@jsaha Sure thing.  Check the attached.  I see you mentioned using a contain, but you need to specifically use a CONTROL container.  See the attached as well as below.  This ensures each container is run in sequence.