Filtering Multiple Columns

[bogdansheremeta]

Below is my sample of data:

[Data]                              [Sacramento?]        Delinquent

Ha                                      No                            No

Da                                      No                           No

No                                      No                          No

Sacramento                       Yes                             No

Ha                                      No                           No

Delinquent                         No                           Yes

I need to proceed with my workflow only if there is a Yes on Sacramento and a Yes on Delinquent. So a Filter tool. However, I cant use IF AND as it will not work. Any suggestions on how to make this work? 

[bogdansheremeta]

This is great. can you post a full workflow for this? @flying008

[DataNath]

I don't see the difference between that and using an OR statement in a filter, as I suggested. Unless I'm missing something?

[flying008]

Hi,@DataNath 

Please look my post output table(the yellow and blue cells), I assume the position is Yes when he needs the value of the [Data] field column to correspond to the names of the following field columns, Obviously you can't do this with just the filter tool.

[flying008]

Hi, @bogdansheremeta 

Dear, I can't post wf because SP.  So you can implement it following the idea of the example flow gif.