Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Overwrite Sheet or Range not working properly

Lalaiah
8 - Asteroid

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

4 REPLIES 4
Qiu
18 - Pollux
18 - Pollux

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

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

 

Lalaiah
8 - Asteroid

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
18 - Pollux
18 - Pollux

@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
5 - Atom

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.  

Labels