Outfile name from column?

[horth007]

Hello 

I am trying to create an .xlsx output file based on a column entry a file name. I tried several settings, but I cannot find the error? 

When running the flow no file was created... What I  have done:

- added my expected file name via formula tool to the data:

- prepared a temp output file on my server

Does any one have an idea where the mistake is? or is the issue that have a three row output?

Thanks a lot

[binuacs]

@horth007 seems to be you are writing all the output in the same file and same sheet. what is the error you are getting?

[horth007]

I prepared manually the Excel file Temp with Sheet1.

I run the workflow and nothing happens, no adjusted Temp file nor a new created file...

Also Alteryx is not showing any error message

[binuacs]

@horth007 after you running the workflow click on the canvas and you will see link for the file created in the bottom output window. Can you check ?

[horth007]

@binuacs Thanks! At least I found the file :-) I checked this and the file was created as expected, but not in the folder as given:

I prepared the Temp file : Z:\Projects\EU\Alteryx\xxxxxxx xxxxx xxxxx\xxxxxx Verification results

and stored: Z:\Projects\EU\Alteryx\xxxxxxx xxxxx xxxxx

I will investigate this....

[horth007 · Accepted solution]

To close the loop; I missed to define the FullPath

// FullPath & FileName
"Z:\Projects\EU\Alteryx\xxxxxxx xxxxx xxxxx\xxxxxx Verification results\"

+[First_Pay Date] + " Pay Date run date " + DateTimeToday()+".xlsx"

//SheetName
+"|||Sheet1

Afterwards it is working as expected!