How to add query on top of a processed dataset

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

Datasets

Preparation

Accepted answers

jrlindem

@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.

Multi Step Workflow.yxmd

All comments

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

Multi Step Workflow.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703