nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update Column based on Multiple Filters

RonitGupta

I want to update Column [Product Family] and there are three filters while binaryAnd accepts two only.

IF BinaryAnd([Plant]="A",[Product Family]="B",[Product Category]="C") THEN "X" ELSE [Product Family] ENDIF

How to deal with that?

I have sometime more than 4 filters too.

Custom Tools

Accepted answers

Felipe_Ribeir0

Hi @RonitGupta

You can use the formula like this, please see if it works for you

IF [Plant]="A" AND [Product Family]="B" AND [Product Category]="C" THEN "X" ELSE [Product Family] ENDIF

Update Column based on Multiple Filters.yxmd

ShankerV

Hi @RonitGupta

You need to use the IF statement without BinaryAnd.

IF [Plant]="A" AND

[Product Family]="B" AND

[Product Category]="C")

THEN "X"

ELSE [Product Family]

ENDIF

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

ShankerV

@RonitGupta

Please use the below.

IF [Plant]="A" AND [Product Family]="B" AND [Product Category]="C"
THEN "X"
elseif [Plant]="A" AND [Product Family]="B" AND [Product Category]="D"
THEN "X"
elseif [Plant]="A" AND [Product Family]="B" AND [Product Category]="E"
THEN "X"
ELSE [Product Family]
ENDIF

IF condition.yxmd

Felipe_Ribeir0

Hi @RonitGupta

Please see if this is what you are looking for:

IF [Plant]="A" AND [Product Family]="B" AND ([Product Category]="C" OR [Product Category]="D" OR [Product Category]="E") THEN "X" ELSE [Product Family] ENDIF

ShankerV

Hi @RonitGupta

Even we can use OR to simplify out if statement.

The below formula also works.

IF ([Product Category]="Absorb, Blott, Chrom" AND [COMM Grade]="MHPM0240" AND [Country]="Canada")
OR
([Product Category]="Absorb, Blott, Chrom" AND [COMM Grade]="MHPM0240" AND [Country]="Colombia")
THEN "Disruptor"
ELSE Null()
ENDIF

What I have done is I have grouped the condition via ().

Condition 1: ([Product Category]="Absorb, Blott, Chrom" AND [COMM Grade]="MHPM0240" AND [Country]="Canada")

Condition 2: ([Product Category]="Absorb, Blott, Chrom" AND [COMM Grade]="MHPM0240" AND [Country]="Colombia")

If either one condition is true it will reflect "Disruptor"

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Multiple Criteria.yxmd

All comments

Felipe_Ribeir0

Hi @RonitGupta

You can use the formula like this, please see if it works for you

IF [Plant]="A" AND [Product Family]="B" AND [Product Category]="C" THEN "X" ELSE [Product Family] ENDIF

Update Column based on Multiple Filters.yxmd

ShankerV

Hi @RonitGupta

You need to use the IF statement without BinaryAnd.

IF [Plant]="A" AND

[Product Family]="B" AND

[Product Category]="C")

THEN "X"

ELSE [Product Family]

ENDIF

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

RonitGupta

Hello Felipe,

Thanks. It worked for me.

I have cases where there are 10 product categories and I need to update only 3 based on already selected two filters. I hope OR should work along with AND.

IF [Plant]="A" AND [Product Family]="B" AND OR([Product Category]="C", [Product Category]="D",[Product Category]="E") THEN "X" ELSE [Product Family] END IF

Felipe_Ribeir0

Hi @RonitGupta

Please see if this is what you are looking for:

IF [Plant]="A" AND [Product Family]="B" AND ([Product Category]="C" OR [Product Category]="D" OR [Product Category]="E") THEN "X" ELSE [Product Family] ENDIF

RonitGupta

Hi,

This is not working. For product category D and E, irrespective of other criteria it give X.

Felipe_Ribeir0

Hi @RonitGupta

When you reach the level 6 (you are current at level 5), you will be able to mention users.

https://community.alteryx.com/t5/Alteryx-Community-Resources/FAQs-User-Ranks/ta-p/178548

RonitGupta

Hi @ShankerV ,

Thanks. I can use the either way now. Very helpful.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15898

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703