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

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

20200602-OddRecords.yxmd