Excel Sensitivity Label

Question

Hi Team,

I hope this message finds you well.

I am currently working on a workflow in Alteryx to automate the processing of Excel files. The workflow involves the following steps:

* Creating a copy of an existing Excel file.
* Retaining only the sheets whose names contain “24” and removing the rest.
* Saving the modified files into a new folder with the same Excel file name.

However, I am encountering an issue where an Excel pop-up appears, prompting me to save the sensitivity label for each file. Given that I have over 300 Excel files to process, this manual intervention is not feasible.

Due to organizational security policies, I cannot disable the sensitivity label feature. Therefore, I am seeking a solution to automatically set the sensitivity label in the Excel files to avoid the pop-up

Image (2).png

Image (1).png

KGT · Answer

Check out this idea and like it if you would like to see it implemented.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/files-as-inputs-to-Alteryx-that-have-been-protected-with-either/idi-p/899382

Note: Please make sure you like it to vote for it. I see a ton of people comment on ideas and not actually vote for them.

Ranjith_udaykumar · Answer

Do we have any status of this idea being implemented in upcoming versions?

KGT · Answer

More info around how the workflow works would be needed to work out a solution. Hopefully someone already has one.

It does seem like a big problem, but one I hadn't heard of before and so rather centralised to firms that use that policy.

Check this out: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/files-as-inputs-to-Alteryx-that-have-been-protected-with-either/idi-p/899382

There is a post with some python code a few comments down where someone manually set the labels using a python tool at the end of the workflow. Not sure if it'll work in your situation, but looks like a good bet.