Basic flow for conditional matching and formatting in a tree

[ShantanuDagar]

I have a record of 20 columns and about 5000 rows.

I have to conduct a conditional checking of data in some columns and then format it accordingly.

For example:

Col A - IDs

Col B - Country

Col C - "xyz" number (121 or 234)

Col D - type ( either p or q)

Col E - (column which needs to be checked) (YES or NO values)

So basic flow goes like:

A country is selected like USA out of all countries in column B. All the rows (with USA) will be checked for Column C and Column D.

If column C has 121 and corresponding D has p then E must contain YES.  (If it rather contains no then that cell in E must turn yellow. But if it contains YES only, then it turns green.)

If column C has 121 and corresponding D has q then E must contain NO.    (similar to above)

similar goes with 134.

And then similar with non USA countries as a whole.

[ChrisTX]

What have you tried so far?  Can you post a sample workflow?  What specifically are you having trouble with?

Do you just not know where to start?

Have you reviewed the training under Learn > Academy > Learning Paths

and Learn > Academy > Interactive Lessons?

Chris

[hellyars]

@ShantanuDagar 

Not exactly sure what you want....

I created a simple IF statement with a True/False output.

[hellyars]

I had a minor error in my first formula.  I just replaced the workflow.  If Test = 1 (True).  If Test =2 (False).

[hellyars]

@ShantanuDagar 

Never try to do Alteryx while talking on the phone.  Found another minor error and fixed it. I replaced the workflow above with a corrected version. 

[hellyars]

Switched to Bool, but basically the same.