Overwrite Sheet or Range not working properly

[Lalaiah]

Hi Team,

There is an issue in Overwrite Sheet or Range as it is not getting updated. I have created output with the department wise then I tested it's working fine. Then I deleted a few department's data when I run the deleted department data also showing which old. as per me, there is no data particular department so it should show an empty sheet. Please help me out.

Attached output setting options

Regards,

Lalaiah

[Qiu]

@Lalaiah 
Recently I  also notice the same behavior similar situation.

Somehow, the Preserving Format fails to "delete" data which is already there.

[Lalaiah]

Hi Qiu,

Really thank you so much for your prompt response on weekends as well!!!

What would be the reason?? is there any other way to do it? 

Regards,

Lalaiah

[Qiu · Accepted solution]

@Lalaiah 
Weekends Alteryx is my hobby. hhee

I am thinking to run a few more tests then maybe report a "Bug"?

And hope someone else can responds and proves us that we did something wrong.😁

[aulman]

This is definitely a problem and I agree that it needs to be reported as a bug.  Once I saw that I could preserve formatting this way I started using it with all my workflows I've modified in the last couple of months.  As it stands now I am going to have to undo all of changes I made.