community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

How to remove specific tabs from Excel?

I run a report everyday that updates two tabs in an excel spreadsheet for more than a hundred users. I recently renamed these tabs but the old tabs are still present. Is there a way to remove the old tabs in Alteryx without manually going into each file? I would still like to keep the two newly created tabs however.

Alteryx Certified Partner
Alteryx Certified Partner

Here's how you could approach the task.

Theres a couple of conditions here though.

 

The individual tabs should have the same schema through each of the files, if the schema of the different tabs is different, that's fine).

 

See link: https://drive.google.com/file/d/1yL0ENv9rSL6Y3U1IRvJ2nSEDbUu9kY5l/view?usp=sharing

 

(I cannot attach it as it is a zip file).

 

Ben

Alteryx Certified Partner
Alteryx Certified Partner

You'll also need the parralel block until done tool from the crew maro pack which can be found here: https://community.alteryx.com/t5/Engine-Works-Blog/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482

 

It is set up as follows:

 

2018-04-11_15-54-32.png

 

Ben

Labels