how to filter rows based on multiple columns value

4 posts / 0 new
Last post
m.a.najimi
Offline
Joined: 11/28/2014
how to filter rows based on multiple columns value

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.

aborg
Offline
Joined: 07/07/2008

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

Cheers, gabor

m.a.najimi
Offline
Joined: 11/28/2014

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

Marlin
Offline
Joined: 10/10/2014

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.