Free Trial

Alteryx Designer Desktop Discussions

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

Copying All Sheets from a Repository to Excel Split Files Issue

themarkknight19
5 - Atom

I have a repository excel file that I need to split into separate excel files where the Outline Agreement ID is the key.

 

I have 2 workflows that I got from a person that also did the same process but I couldn't make it work properly for my end.

I already edited the workflow and put all of my files and paths. And when I run it, it does the splitting of excel files but it does not copy all of the sheets/tabs from the repository to the split files.

 

The repository has 4 tabs/sheets but the output split files only contain 2 of the 4 tabs/sheets from the repository.

I need all of the 4 tabs from the repository to the split files.

 

I am also encountering this error when I run the first workflow: "...returned an error code: 1: The operation completed successfully. (0)"

 

I have attached my workflows and the files that are needed to run.

Hoping you can assist me with this as this is high priority in my project

Thank you very much!

 

10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

Hi @themarkknight19 ,

 

If this helps please dont forget to mark the post as solution.

 

This helps people to find article.

 

And counts to our authored solution and people we were able to help.

 

Happy to help : )

 

Cheers and Happy Analyzing : )

Labels
Top Solution Authors