Conditional Filtering

[romachainani]

Hello Everyone, 

So I have this snippet of the dataset that I need to filter out. Basically, columns Blue through Purple are going to always have values of 'Yes, No, and Not Sure'. The ID column is a group id column that  may or may not change everyday. The values in the 'Color' column will most likely change daily, and this is where I get confused as I need to filter out rows based on those values. For example if the value in the Color column is set to 'Red', and the value in the Value column is set to 1 today, I will need to filter out any row in the 'Red' column that does not equal 'Yes'. 

1 - yes

2 - no or not sure

ID

Blue

Red

Black

Pink

Yellow

Orange

Green

Purple

Color

Rule

Value

What needs to be done

1

No

Yes

Yes

Not Sure

No

No

Yes

Yes

Red

is not a part of

1

Filter out rows where column 'Red' is not equal to 'Yes'

1

Yes

Yes

Not Sure

Yes

No

Yes

Yes

Not Sure

Green

is not a part of

1

Filter out rows where column 'Green' is not equal to 'Yes'

1

Not Sure

Not Sure

Not Sure

Yes

No

Yes

Not Sure

Not Sure

Red

is not a part of

1

Filter out rows where column 'Red' is not equal to 'Yes'

1

Not Sure

No

Yes

Yes

No

Yes

Not Sure

Not Sure

Green

is not a part of

1

Filter out rows where column 'Green' is not equal to 'Yes'

2

Yes

No

Yes

Not Sure

Not Sure

No

Not Sure

No

Red

is not a part of

2

Filter out rows where column 'Red' is not equal to 'No or Not Sure'

2

Yes

Not Sure

No

Not Sure

Not Sure

Not Sure

No

Yes

Green

is not a part of

2

Filter out rows where column 'Green' is not equal to 'No or Not Sure'

1

Not Sure

Not Sure

Yes

Not Sure

Yes

Not Sure

No

Yes

Purple

is not a part of

1

Filter out rows where column 'Purple' is not equal to 'Yes'

2

No

Yes

No

Not Sure

Not Sure

No

Not Sure

No

Red

is not a part of

1

Filter out rows where column 'Red' is not equal to 'Yes'

1

No

Yes

Not Sure

No

Not Sure

No

No

No

Green

is not a part of

1

Filter out rows where column 'Green' is not equal to 'Yes'

Thank you!

[rzdodson]

@romachainani: This should be able to help you out. This use case screams "Transpose"! :)

I have created an analytic app for you that will bring in the known colors in the Color field (Red, Purple, Green) as the selectable parameters (Yes, No, Unsure). User should be able to make their selections, and it'll output the filtered results for you in the same directory where you saved this workflow.

Let me know if you are looking for something else, and I'll be happy to help you out!

[romachainani]

@rzdodson is there a way to do this without an analytic app - we do not want users inputting anything. 

Best, 

[rzdodson · Accepted solution]

@romachainani maybe something like this (see attached)?

You'll just have files or even Text Inputs that control the Color and Conditions you are looking for.