Include 1st query output in second query where condition.

[Niru]

Hello All,

I am pulling directly data from sql server. Here each table has millions of records. With query1 matching records i need to pull data from other tables. Is there any way i can pull only matching from other tables without using join ( if I use join it is taking more than 4 or 5 hours to pull the data from other tables).

In Alteryx query builder i have joined all the queries together i got  the unexpected results. now im unable to validate the data.

Is there any way I can include 1st query output in second query where condition. Please suggest me any other way.

kindly help me 

Thanks in Advance,

Niru

[atcodedog05]

Hi @Niru 

I guess you are looking for something like temp table creation in SQL. And sadly alteryx doesnt allow temp table reference.

[Niru]

Hi @atcodedog05, Thanks for your reply 

Is there any other way can we achieve the logic.  

Thank & Regards,

Niru

[danilang]

hi @Niru 

Look at using the In-DB tools. You should be able to set it up as an In-DB join so the query runs completely in the database and only the final results are returned to you.

Dan

[atcodedog05]

Hi @Niru 

Thats right as @danilang suggested you can convert approach on this post link to in-db tools that way its similar to sql query and should take less time.

[atcodedog05]

Hi @danilang 

I have a similar situation but i am not allowed to use in-db tool because of a password vault limitation (maintains & changes the password). Is there any other workarounds using normal tool only?

[Niru]

Hi @atcodedog05 @danilang Thanks a lot for the quick respose 

kindly help me with sample workflow or how to built workflow using In-db tools. 

Thanks & Regards,

Niru

[atcodedog05]

Hi @Niru 

The workflow would be identically same expected normal tools replaced with in-db tools. Here is a video lesson which would give you a good overview of usage https://community.alteryx.com/t5/Videos/In-Database-Workflows/td-p/330566 

Hope this helps 🙂

[Niru]

@atcodedog05  Sure i will do check 

[Niru]

Hi @danilang, 

When I am running workflow using Browse In-DB tool i got below error message. I am not sure what is the type of error. Could you please help me on below DB browse tool error. kindly suggest me.

 

Thanks in Advance,

Niru