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!
Solved! Go to Solution.
@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!
@rzdodson is there a way to do this without an analytic app - we do not want users inputting anything.
Best,
@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.