Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

IF condition with True & False Criteria

Vicky92
7 - Meteor

Hi Team,

 

I want to apply conditional formatting for my output in the form of True & False. If X amount is equal to Y then the condition for Y amount should be ":True" else "False". The formula are to be applied row wise.

 

My Alteryx input & output required are attached for reference.

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Vicky92 
Can you elaborate your requirement a bit more?

There are two sheets in the attached Excel file.

atcodedog05
22 - Nova
22 - Nova

Hi @Vicky92 

 

Is this what you are looking for comparing current and previous row.

Here is a workflow for the task.

Output:

atcodedog05_0-1604998913473.png

 

Workflow:

atcodedog05_1-1604998930401.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

atcodedog05
22 - Nova
22 - Nova

Hi @Vicky92 

 

As @Qiu mentioned there are other sheets Input and Output. Seems for a different task.

Labels
Top Solution Authors