Multifield Filter.

I'm trying to get multiple filter conditions to work in the same condition, but somehow it doesn't work when run together, but they do work separate from each other.

Below is the the custom filter I am using. What am I missing?

StartsWith("XXX", [Segment2]) AND StartsWith("XXX", [Segment1])

Preparation

Accepted answers

You just need to swap the arguments.

Cheers,
Mark

All comments

Your statement will return only records that meet both criteria.

I.e. the value in segment2 for a row starts with XXX and the value in Segment1 for the same row starts with XXX.

Segment1	Segment2
XXX1	XXX2
XXX1	YYY2
YYY1	XXX2
YYY1	YYY1

From the above table your filter will only return the single top line where both criteria are met.

If you want either, then it must be an OR statement.

Based on an OR statement using the above table, lines 1,2,3 will come out of the T and line 4 through the F.

See attached.

Ben

Example Logic.yxmd

You just need to swap the arguments.

Cheers,
Mark

Didn't even clock that one @MarqueeCrew!

Thank you for this, it is confusing though as the Alteryx syntax states:

StartsWith(String, Target)

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703