Hi All,
I am trying to output data from Alteryx output tool to SQL Server database. I would like to delete the old records(which I am trying to insert) for that particular period from database before insert.
Solved! Go to Solution.
Thank you Chris! I spent ages trying to do this, I used your solution and got it working in no time!
Thank you so much, Chris. Your macro example was clear and I managed to adapt it to my needs. Been trying to find solutions for three days now. Can't thank you enough!
Your solution is helpful, is it possible to pass dynamic arguments to 'pre create sql statement' instead of hard coding.
Hello.
When I try to do this in my App, the Batch Macro tries to process(write) the Input data multiple times. For example, if the data I send in has 20 rows, it will try to add those 20 rows 20 times! Is there a configuration I need to have to make it only process my input data 1 time?