case switch database with date

pio · September 20, 2021, 11:46am

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

mlauber71 · September 20, 2021, 11:52am

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

pio · September 21, 2021, 7:55am

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

ipazin · September 22, 2021, 9:42am

Hello @pio,

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

Br,
Ivan