Range in 'IN' functionality

[Pawel_Paleczny]

Hello,

Enhancement of 'IN' functionality (ie. in Filter tool), so using range instead of citing particular values for example:
instead [ID] IN (1,2,3,52,53,54,100,101,102) something like that [ID] IN (1-3,52-54,100-102).

[ddiesel]

I would use this feature if it was available.

[DavidP]

Awesome idea @Pawel_Paleczny !!!

This would be so useful!

[Thableaus]

I support this idea @Pawel_Paleczny!

[cgoodman]

@Pawel_Paleczny this would be good to have as it would replicate the select records functionality where you can specify a range.

However I have couple of questions:

- Just having a look at the IN statement in SQL I am not sure if you can specify a range like how you have shown - https://www.w3schools.com/sql/sql_in.asp therefore how important is it to you that Alteryx syntax is inline with other common languages?

- Because there are no other qualifiers, how do you expect the value 52-54 to behave, is it to include 52 and 54, or only return 53 as the value between the range? 

[atcodedog05]

This is an amazing Idea @Pawel_Paleczny. I support this idea 🙂👍

I like/agree with @cgoodman point of view too. Just a thought Instead of embedding it in the IN function maybe we can create it similar to the Between-https://www.w3schools.com/sql/sql_between.asp function of SQL.

I am ok with however it will be implemented. I support the concept of this Idea 😀👍

[Pawel_Paleczny]

Hello!

@atcodedog05 thanks! Your idea to use BETWEEN statement will be perfect here!

@cgoodman I believe that BETWEEN functionality will resolve all problems! You're right re IN statement in SQL however my idea was based on real case where I had to type all values from my list and creating range will reduce significantly time spend on it :)