Hello,
I have data being split into 3 different sheets of a single excel file. I am able to write to a static excel file (by naming sheets in the excel file) with 3 different tabs created, however I want the "excel" (not csv please) output in todays date and my data still being split into the 3 sheets within that file.
Solved! Go to Solution.
Hi @danishrizvi ,
It says you are missing sheet name.
Like |||Rawdata etc which needs to be at end of the path.
Can you check this out. If issue persists please attach snapshot of the path formula of Y drive formula
this is the formula I am using in the formula tool -
"Y:\A**** C*****l\D**** ****rts\Alteryx Output Files\Output_"+left(DateTimeNow(),10)+".xlsx|Raw Data"
this is what is on the output tool -
Y:\A***** C*****l\D**** ****rts\Alteryx Output Files\Output.xlsx|||Raw Data.
When I change both the paths above to my C drive. it works perfect and the output comes as expected.
Hi @danishrizvi
Just a hunch can you convert formula as below.
"Y:\A**** C*****l\D**** ****rts\Alteryx Output Files\Output_"+left(DateTimeNow(),10)+".xlsx|||Raw Data"
Replace |RawData to |||RawData
Donno why its working in C and not in Y.
Nah! Doesn't help. Edited to 3 pipes ||| on both locations and edited it to one pipe | on both locations (formula and output) as well. But alas.
It only works on my C drive
Hi @danishrizvi
Yikes dont know man.
I wish i could try but i have only C drive.
I guess Alteryx can output only in the main drive.
Anyways will let you know if i find anything.
If any of my post helped please mark it as solution.
And it will be helpful for other people find the solution.
Cheers and Happy Analyzing : )
Thank you. Appreciate you looking into it.
Happy to help : ) @danishrizvi
@atcodedog05 - (Trying using relative path instead of absolute path.
I.e just a file name format instead of whole path)
Not sure why I missed this comment of yours. The above step just worked perfectly for the shared drive error/issue.
I can now write to my shared drive without the "specify sheet error." Sorry for wasting some of your time with the other steps. Thanks a million
Haha
Anyways glad I was able to help you out
Happy to help : )
Cheers and happy analysing : )