Designer - In-DB Custom Filter using multiple 'IN' & 'OR' conditions

The following custom filter statement is omitting results from 'ultimate_parent_id' & ''legal_entity_id' columns I expect to see when I run the workflow(i.e. these numbers are in my data set)

Can the syntax be changed to make this work or other solution I can try ?

( organization_id IN (10002456, 345678)

OR ultimate_parent_id IN (543290, 56704)

OR legal_entity_id IN (114320, 657890) )

Thanks

Data Investigation

Accepted answers

Garabujo7

Hello @Brian_Foody ,

It will be helpful if you provide some data as Arturo said.

Here is the Alteryx sintax for that filter:

Gabriel

All comments

atcodedog05

Hi @Brian_Foody

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

Garabujo7

Hello @Brian_Foody ,

It will be helpful if you provide some data as Arturo said.

Here is the Alteryx sintax for that filter:

Gabriel

terry10

Your custom filter is equivalent to:

IF organization_id = 10002456
OR organization_id = 345678
OR ultimate_parent_id = 543290
OR ultimate_parent_id =56704
OR legal_entity_id = 114320
OR legal_entity_id = 657890
THEN 'True'
ELSE 'False'
ENDIF

So, if any of these 6 conditions is True the record will flow out the T anchor.

The F anchor output will only have records in which all of these 6 conditions are False.

What is your desired output?

apathetichell

in (in alteryx at least) is a string term. Those are numbers. the proper format for alteryx would be in organization_id IN ('10002456', '345678')

Brian_Foody

Thanks All -it turned out to simply be an issue with the browse tool not loading the records I searched for and expected to see. When I looked them up using a filter tool I could see the were passed through correctly using my original syntax. Appreciate the replies

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703