Filtering with large amount of conditions

[coderman]

Hey,

I have a list of conditions in excel, more than 100 unique numbers, that I would like to use as conditions in filter, separation with "OR".

Manually its very slow to start putting these into the custom filter one by one. Any quick tips on how to automate this filtering?

[binuacs · Accepted solution]

@coderman One option I am thinking put all these unique numbers in a text input tool and connect this and the input file with the join tool. Then take the records from the L anchor of the join tool

[IraWatt]

Hey @coderman,

Can you give some example input data, your excel unique number format with your expected result. Just to give an idea of how to approach this?

Thanks,

Ira

[coderman]

yeah so I have excel where I have
1
2
3

4...

and I want to use all these as a condition for a given column to find these lines.

[IraWatt]

Without a full example I am still a little confused but It sounds like @binuacs's solution is the way to go.