Alteryx Designer Desktop Discussions

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

Formulating

Sunilmnv
5 - Atom

Hello there, team.
I need your help in formulating.

I've got two columns, a and b. If a=fail, then the b column should not be empty.

4 REPLIES 4
DataNath
17 - Castor
17 - Castor

@Sunilmnv this is a little vague. Are you saying where [a] = fail and [b] is empty, you want to filter those out? Or you want to populate [b] with a certain value? What does your input look like and what do you want the outcome to be? Would be great if you could provide an example.

IraWatt
17 - Castor
17 - Castor

Hey @Sunilmnv,

Does this give the logic your looking for?

IraWatt_0-1656597284034.png

The formula passes the value for B if A = "fail".

Any questions or issues please ask :)
HTH!
Ira

Emeritus001
5 - Atom

Hi @Sunilmnv, may I ask for further details on the condition like what could be other text in the column A aside from 'fail' and if column B should not be empty, what data should be written in there.
Anyhow, I wrote a simple workflow that satisfy basic condition. You may change the formula as you desire.

Sunilmnv
5 - Atom

It’s a free text any thing can be written but should not be blank

Labels
Top Solution Authors