Using the 'Contains' function

Hello,

I am using the contains function to filter on just specific named strings within my data set as follows:

Contains([Product Type], "Asset Purchase Plan") or
Contains([Product Type], "Lease") or
Contains([Product Type], "Long Funding Lease")or

The problem is that this is returning any result with any of these words contained within data set, not the specific ones in the " ".

Can anyone provide some guidance on how to re-write this so it just returns the above?

Many thanks

Preparation

Accepted answers

All comments

carlosteixeira

Hi @StephenG, follows a working workflow. What version of Alteryx are you using? I hope it helps.

Filter Contains.yxmd

MarqueeCrew

Could it be ther trailing or at the end of the formula?

StephenG

Hi,

Thanks for your response

I am using version 11.7.4

The problem is that I have other values in the data set such as 'Lease Regulated' which is also being returned, whereas I am trying to return just 'Lease' or "Long Funding Lease"

Thanks

rohit782192

Hello ,

I tried but ran into a problem i want to check the data should include Asset Purchase Plan or Lease.

Neither way i am getting proper output

richmondbound

Hi,

I am trying to check if the concat_category contains "pizza", "burger", or "side" and "drink". As you can see from the example weekly challenge. What I am struggling with is how to check if the field does in fact contain these values. Unfortunately when I use the contains(pizza",concat_category) it returns 0. What I am realizing is that contains() is checking if the entire field contains the specific word i am looking for. Any thoughts on how to work around or how to deal with this?

challenge_8_start_file.yxmd

nukamanoj

If data under comments heading starts with "JP" then the value under "Department" column must become "JPY", If starts with "DE" then department should become "DEN". Others should remain as TSL. Please help to build workflow for this case.

CurrReplace.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703