My Input data stream is excel and it contains dates along with other data. If I run workflow twice, data is getting appended twice to sql table resulting in duplicate rows. So to avoid data duplicacy, I need to delete the data from sql table which is greater than minimum date of input data stream before appending the data from excel to sql table.
I am able to find minimum date by using summarize tool. How can I pass these minimum date to pre-sql statement so that I can delete previously appended data.
For example, I have last week data. Once I run macro, last week data get appended to sql table. If I re-run the query, last week data get appended to table again. Becuase Data doesn't have any unique colomns so database don't throw any error.
I am trying to delete the last week data if exists by using pre-sql statement. I am getting last week min date "07/10/2016", I am not sure how can I pass this date to pre-sql statement.
Thanks in advance.
