Right now, I am using nested filters to make multiple decisions on data. I've also used nested if then else filter statements.
These are wonky workarounds that are difficult to create and difficult to troubleshoot.
What I'd like is a real switch tool I could drop in and have a single input and an arbitrary number of outputs.
switch (age) {
case 1: printf("You're one."); break;
case 2: printf("You're two."); break;
case 3: printf("You're three."); break;
case 4: printf("You're four."); break;
default: printf("You're neither!")
}This is what I am talking about.
My use case is that I have data in a spreadsheet and I need to break some of the columns into multiple columns. Unfortunately, the formula for how the column should be parsed varies based on the value in another column.
Specifically, it is vulnerability data and the different products need to be parsed differently to get something that looks uniform after the transformation.
Hey, look. I've attached a sample workflow and spreadsheet!
