Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have a project's current scenario as daily refresh of data and sending to Tableau server based on SQL query change trigger. I have a SQL that is checking the system load date. If system load date = today's date then the trigger will start. My question is how do I keep the current scenario and send dataset via email every 2 weeks?
Operating system used: Windows
Operating system used: Windows
Hi,
My first idea would be to configure the built-in Mail reporter, and to change the Run condition to include a variable that you can set in a Python step. You would first have to set up a global variable as a reference point for the 2 weeks condition.
So something like:
Mail Report + Run condition:
Global variable:
Custom Python step:
Its not very pretty but I hope it helps!