Selecting Specific Rows in Dataset

[Sntrada]

Hi guys, 

I was wondering what the best way is to select specific rows in a dataset. Right now I am using a filter tool with this formula:-

[RecordID] = 1
OR [RecordID] = 3
OR [RecordID] = 5
OR [RecordID] = 7
OR [RecordID] = 9
OR [RecordID] = 11
OR [RecordID] = 13

But I was wondering if there is a better approach. I was not able to use the select records tool since that one deals with ranges. 

I'm only one week into Alteryx, so I will appreciate any help from the more experienced users.  

[CharlieS · Accepted solution]

Hi @Sntrada 

Based on the example you provided, the Select Records tool gives the advantage of being easier to specify values

1

3

5

7

9

11

is easier to enter than the expression you gave. If you want only odd rows, I would suggest using a Filter tool with the MOD( function. Here's the expression I used:

Mod([RecordID],2)

If there's another formulaic method you're like to use to select rows, let's talk about it and see if the Community can figure something out. 🙂 

[RobertOdera · Accepted solution]

Hi, @Sntrada 

With Alteryx, the options are many.

But always also examine the field size that is generated (you might need to increase it whenever some present as byte).

[Sntrada]

@CharlieS So I tried the select records tool before, but I entered ranges like so:-

1,3,5,7,9,11,13

The result only provided the 1st record and ignored all the other records

Now I see from your solution that I was setting up the tool wrong. I did it the way you specified and it works wonderfully. 

Thank you!

[Sntrada]

Thank you @RobertOdera!  I'm saving that graphic for future reference. 

[RobertOdera]

You're most welcome @Sntrada