Excel Sensitivity Label

[Surajnair]

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:

1. Creating a copy of an existing Excel file.
2. Retaining only the sheets whose names contain “24” and removing the rest.
3. 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

[KGT]

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...

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.

[Ranjith_udaykumar]

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

[KGT]

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...

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.