case switch database with date

Hi,
I would like to connect from the table that I created, depending on the day of the week to run certain rollup from the original table - see the attached pic. I can’t seem to find a case switch that is able to connect to the DB SQL EXECUTOR. Any idea how I could make this work.
Thanks
Pio

@pio this example is with Python nodes but you might also use it with DB-nodes.

4 Likes

Hi @mlauber71. It worked like magic. Thanks for pointing it out
Regards
Pio

1 Like

Hello @pio,

you should also be able to use Case Switch Model node(s). See here:

Br,
Ivan

3 Likes