Filter data out

Hi all

i need to filter some rows out of my data set based on characteristics of some fields

In my image, I need to filter the select row based on KUNNR and VKORG.

I tried [KUNNR] != "0000025664" AND [VKORG] != "FW02" but it actually filtered out all rows with KUNRR = 0000025664 and all rows with VKORG = FW02.

I'm sure that i'm not using properly the combination of "!=" and "AND" operators but i just can't figure it out

Thank you

Francisco

Workflow

Accepted answers

ChrisTX

try

!([KUNNR] = "0000025664" AND [VKORG] = "FW02")

All comments

fmarin00

I'm sorry, in my original posting I didn't specified that i want to Filter out Line #2 from the data set.

thank you

Francisco

JoBen

@fmarin00, you could use a Select Records tool and set it up the ranges like below.

mmenth

Hi, @fmarin00,

Based on what you've shown from your screenshots it looks like it should be working correctly, that is, it should only be filtering out Row 2. Could you perhaps share your workflow so I can see if something else is amiss? (You can share by exporting your workflow: Options -> Export Workflow).

Best,

mmenth

ChrisTX

try

!([KUNNR] = "0000025664" AND [VKORG] = "FW02")

mmenth

Ah yeah @ChrisTX is right.

@fmarin00, the way you have it phrased right now, only things that are TRUE for both [KUNNR] != "0000025664" AND [VKORG] != "FW02" will go through the T output node.

To simplify you could also do [KUNNR] = "0000025664" AND [VKORG] = "FW02" and then continue with the F output node.

Best,

mmenth

fmarin00

ChrisTX

That worked perfect!

Thank you

Francisco

fmarin00

@mmenth You are correct, I didn't describe the required outcome properly . I needed to eliminate row 2 from the results. @ChrisTX solution was what I was looking for.

Thank you all

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703