how to filter rows based on multiple columns value


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.

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

Cheers, gabor

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

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.