Hi,
I'm posting this since I've found the solution and it could come in handy for someone else.
I was trying to split my output into multiple Excel and save to multiple different directories/folders based on fields in my data. My data looks like:
I would like each Program to be its own Excel file AND I would like to save the output to a folder that matches the School. So all the data related to 'Acting for Film and Television - P0198' would be written to
...\Schools\Media\Programs\Acting for Film and Television - P0198.xlsx.
I've successfully created the files and dumped them in the correct folders by creating a column named FileNameAndPath:
"C:\Temp\Schools\" + [School] + "\Programs\" + [Program] + ".xlsx|||DATA"
then used this in the 'Field Containing File Name...' parameter in the Output Data tool:
This works fine, but because I need to format the output and I don't want to have to 'touch' the resulting 137 Excel files, I decided to try the Table and Render tools instead of the Data Output tool. The output looks much nicer, but unfortunately, I lost the ability to change the destination folders on the fly. E.g., for the Table I have:
And for the Render I have:
Alteryx Designer really doesn't like this and throws an error:
Error: Designer x64: The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.
The solution is to remove the explicit sheet name from the PathAndFileName column and instead use:
"C:\Temp\Schools\" + [School] + "\Programs\" + [Program] + ".xlsx"
And it works like a charm!
If anyone figures out how to rename the sheets using Table/Render tools, please let me know. Thanks to both @messi007 & @JosephSerpis for their help.
--sue
Solved! Go to Solution.
