how to filter rows based on multiple columns value

m.a.najimi

hi.....

i want to filter rows based on values of multiple columns.............

i have to repeat row filter several times(as many as columns count),is there any better approach?

thanks alot.

Comments
Tue, 12/02/2014 - 08:09

Member for

9 years 2 months

aborg

Unless you have special conditions for the values the Rule-based Row Filter/Splitter might be what you are looking for.

Cheers, gabor

Tue, 12/02/2014 - 08:35

Member for

2 years 9 months

m.a.najimi

thanks alot............

Tue, 12/02/2014 - 08:40

Member for

2 years 11 months

Marlin

For me, when I encounter such a problem, I often find that my data is not in the perfect shape yet. Maybe tagging values instead of spreading them into columns helps, or filtering before joining, or something along these lines. One small refactoring like that can go a long way to simplify whole workflows.

If neither this nor the Rule-based tools work, there are always the recursive loops.