Filter Out data from Dataset

I am trying to filter out data from my dataset. I want to filter out data that match two conditions in two columns in my workflow. Here is the formula I have written out but this is going to filter the data for this data and I want everything but this data

Contains([CountDistinct_receiving_entity], "1") and contains([Allocation Condition],"X"

Datasets

Developer

Developer Tools

Input

Settings

Output

Custom Tools

Expression

Database Connection

Accepted answers

binu_acs

@Klachner updated the original post

!Contains(toString([CountDistinct_receiving_entity]), "1") and !contains([Allocation Condition],"X")

All comments

binu_acs

@Klachner can you try

!Contains(toString([CountDistinct_receiving_entity]), "1") and !contains([Allocation Condition],"X")

Klachner

The error I get is "Parse Error at char (2): Formula tried to apply string operator to numeric value (contains)"

binu_acs

@Klachner updated the original post

!Contains(toString([CountDistinct_receiving_entity]), "1") and !contains([Allocation Condition],"X")

Klachner

Amazing! Thank you!

Klachner

Upon further review.. this formula is filtering out both CountDistinct_receiving_entity]),=1 AND Allocation Condition= X... I want it to have to meet both conditions to be filtered out. So if CountDistinct_receiving_entity =1 and Allocation Condition is Y i want that data to stay in the dataset

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703