asked
Removing client IDs from different categories
I’ve built a query with 4 different status: 1. Level 1 2. Level 2 3. Level 3 4. Level 4 I have client IDs which can be in any of the above categories. I’m trying to create sort of a waterfall affect. If a client is in level 1 then I’d like to remove them from any of the other levels. Then moving to level 2, the client Id cannot be in levels 3 and 4 and so forth. Can someone please help me figure out the best way to attempt this? I’d really appreciate it.
@Johntl17 Please provide some sample data or elaborate a bit. It is not clear whether the categories are **columns**, so every record with specific client ID has some of the columns' values set to, say, 1, or you have **multiple rows** with the same client ID value and would like to delete the rows based on the logic in your question. Thank you.
18 People are following this question.
