Multiple commands in If-Then-statement

Hello,

Is it possible to to include two different sets of commands in an IF THEN ELSE statement? E.G.

IF [Category Description] = 'STIF' AND [Term] = 'Long Term' THEN

[Category Description] = 'Short Term' Else 0 ENDIF

Basically I need the formula to Check the Category Description field to see if it contains 'STIF', if Category Description does contain 'STIF' then check the Term field to see if it is 'Long Term', and if both of these are true then the Term field changes those that contain 'STIF' in Category Description and 'Long-Term' in Field to 'Short -Term' and the rest stay the same. Is this possible? Would the Multi Field Formula be able to do this?

Workflow

Datasets

Macros

API

Database Connection

Alias Manager

Adobe

Accepted answers

BenBo

You have the logic correct by including the AND statement in your IF clause. I like to wrap things in parentheses as it makes reading it a bit easier. For example:

if ([Category]="STIF" AND [Term]="Long Term")
then "Short Term"
else [Category]
endif

In this example, I'm simply updating the existing column named Category. I've attached a very simple workflow that may help.

MultiCondIf.yxmd

Thableaus

Hi @Michaelovermyer

This is what you're looking for:

Field in Formula Tool: Term

IF Contains([Category Description], 'STIF') AND [Term] = "Long Term" THEN

"Short Term" ELSE [Term] ENDIF

Cheers,

All comments

BenBo

You have the logic correct by including the AND statement in your IF clause. I like to wrap things in parentheses as it makes reading it a bit easier. For example: