-
Re: Dynamic SQL creation using SQLExecutor2 fails
Hi, Thank you for your question! So one limitation with exec_recipe_fragment() is that you can only execute one main query. That said, you can always execute as many pre-queries as you want by passin…1 · -
Re: Converting week and year to datetime stamp using Python function in prepare
Hi, Thanks for bringing this up - it is an interesting case. After reading the datetime documentation, it turns out that the %W directive does not respect the ISO definition of week numbering. To fix…2 · -
Re: Converting week and year to datetime stamp using Python function in prepare
Hi, You can run the following code (datetime is a core package of python) from datetime import datetimedef process(row): year = row["year"] week = row["week"] date = "{}-{}-1…2 ·