We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

help in filter function.

anonymous008_G
8 - Asteroid

Hi,

I have below dataset where using filter function i want to instruct alteryx to from recordID 16 onwards filter the value as derivatives, Long, Short and cells containing FX from sector column. 

I have tried below code but this is not working. it is filtering all the values from record ID 1 to 23 but i want specifically filter from RecordID 16.

Can someone please help.

RecordID>= 16 and [Sector] = 'Derivatives' or [Sector] = 'Long' or [Sector] = 'Short' or Contains([Sector], 'FX')

 

RecordIDSector
1FX-D
2FX-C
3FX-B
4FX-A
5Short
6Long
7FX-A
8FX-B
9FX-C
10FX-D
11Long
12Long
13Long
14Long
15Long
16Derivatives
17FX-A
18FX-B
19FX-C
20FX-D
21Short
22Long
23FX-A
2 REPLIES 2
Deano478
12 - Quasar

Hey @anonymous008_G give this modified filter expression a try:

 

[RecordID] >= 16 AND ([Sector] = 'Derivatives' OR [Sector] = 'Long' OR [Sector] = 'Short' OR Contains([Sector], 'FX'))
anonymous008_G
8 - Asteroid

@Deano478 -- this works. thanks a lot

Labels
Top Solution Authors