Excel Output to Current Date with Data in 3 sheets

[danishrizvi]

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. 

[danishrizvi]

The only thing I am changing are the file paths in the formula tool and the output tool.

Both screenshots attached - One where it runs good on C drive. One where it error outs "You must specify a sheet name" on shared drive.

[atcodedog05]

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

[danishrizvi]

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.

[atcodedog05]

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.

[danishrizvi]

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

[atcodedog05]

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 : )

[danishrizvi]

Thank you. Appreciate you looking into it.

[atcodedog05]

Happy to help : ) @danishrizvi 

[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

[atcodedog05]

Haha

Anyways glad I was able to help you out

@danishrizvi 

Happy to help : )

Cheers and happy analysing : )