Saving Excels Splits to wrong folder

[Hursan]

I have a workflow that splits records in chucks of 2000 records per file, the workflow kind of does it job but its saving the files to the wrong folder. I am not sure what am I doing wrong.

The output file should be going to:

\\....\Database\AutoReports\RESL Folder\Block.xlsx|||Sheet1

But the its actually saved to:

\\......\Database\AutoReports\Database_Folder

i recreated the workflow multiple times and the output file is always gong to the wrong folder.

 

 

  

[OTrieger]

@Hursan 

I can see that the fixed path is \\....\Database\AutoReports\RESL Folder\Block.xlsx|||Sheet1 in the Output tool.

What is the path that you get in the field that contains the full path (FileNamingBlock) based on your formula?

My assumption is that the automation is using the path that defined in that field. You need to ensure that in that field you have the correct path.

[binuacs]

@Hursan you need to mention the full path along with the file name in  the formula tool