Forum Discussion
Filter rows on multiple conditions with different values
We can merge the status and employee columns into one with a delimiter (I like to use the pipe | ).
Then pivot on task name, split by delimiter and finally rename the columns to end up with this.
I have attached my sample file for you to look at the steps in the query editor.
How many tasks do you have in your real data? I am struggling with thinking of a clean way to filter by multiple task statuses where each task has a user except maybe a table for each task that has Client ID, Task Status, and User.
For this usecase, I will need to look at the status of 3 tasks to determine in which phase the clients are.
So eventually I will have the following lists with clients where:
- A1 still Open
- A1 Done, but A4 Open
- A4 Done
I can get behind your idea to create tables for each task, but then how will I come to the A1 - A4 list? By comparing them through hierarchy based on client number?
If there is a way to create the columns 'A1 employee' and 'A4 employee' and get the correct data in, that would be good too, because it will keep my amount of tables low and all the information regarding a client in one specific row.