How to use IN clause in alteryx

is it possible to implement SQL IN clause using alteryx tool(s)?

for example,

select * from table1

where ID IN

('10','20','30')

if the number of values are less we can directly put those within the query of Input data node as above. But it's not feasible if there is couple of thousand records. Is there any alternate way to do this in alteryx?

thanks!

Developer

Developer Tools

Custom Tools

Accepted answers

All comments

Tyro_abc

Yes, you can use "IN" without "WHERE", like below.

    [Inspection ID] IN ("1640216","1647217")

Regards

Arundhuti

grazitti_sapna

Hi @tanvir_khan, you can try using a filter tool after reading the data from the file. Please refer to the attachment and screenshot below.

If this is what you are looking for kindly mark this post as solution.

Thanks.

Filter-GS.yxmd

Qiu

@tanvir_khan
Add to @Tyro_abc

In case your [Inspection ID] field is numeric, then

[Inspection ID] IN (1640216,1647217)

tanvir_khan

Hi .@grazitti_sapna and .@Qiu

I think my problem title didn't quite reflect what I'm looking for. Sorry guys.

Basically I want to filter out while I'm fetching from database cause the number of records are millions and it's time consuming. So, instead of fetching all the records, I want to filter with values [this is again couple of thousands].

For example,

DB-Table

50 million records

I need to look up 50k records only out of 50M.

So, I don't want to get all the 50M records, I'd like to fetch 50k out of 50M and analyse those only.

We do such thing in database by creating a look up table and using IN clause in the query. How can we do it in alteryx?

Thanks!

amueller2

I know this thread is not active, but I stumbled across it and I've been in a similar situation before. What I did was use get the list of values that I needed, and then write a SQL query in a dynamic input tool like

SELECT * WHERE column = [value]

I then used the Dynamic input tool with the "Modify SQL Query" option with "Replace a Specific String" to replace string "[value]" with the necessary value.

DonnaFazio

Is it possible to use an IN statement where it does not contain?

tanvir_khan

Hi @amueller2 thanks for your response. can you please explain it a bit or share the solution with us.

thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703