What is the best way to implement a switch statement in my DataFlow?

[gdaccache]

Consider a simple switch statement involving an integer:
int day = 3;
switch (day)
{
case 1:
Console.WriteLine("Monday");
break;
case 2:
Console.WriteLine("Tuesday");
break;
default:
Console.WriteLine("Invalid day");
break;
}
My current default is to use a string formatter with parameters to generate a SQLite case statement, which is then fed into a table query (no table needed in this case):

What other approaches are out there? If you've needed to implement a switch statement before in your DataFlow, especially for more complicated contexts than this one, please share any tips or tricks on how you achieved it.

[andyvidan]

Your current approach using a String Formatter to generate a CASE statement works well. Just a few tweaks to perhaps reduce the number of Modules needed:

• Use Key-Value Pair Module to define a sql parameter, to reduce the need for the String Formatter Module
• Use the Table Scalar Module, which executes the query and returns just the first column of the first row (with all other columns, rows ignored). This will remove the need for a Table Cell Selector Module.