Input name --> Output name

[bakaidora]

Hello All,

I have a .csv file and on that file I made some modifications. At the end of the workflow, I would like to save the output into the same folder and with the same name as the input BUT with .xlsx.

Could you please help with this?

Thank you.

[hellyars]

The Output Data tool will allow you to do that.  Just set the destination to the same and make sure you have the output set to XLSX.   or am I missing something.

[bakaidora]

I missed to mention the the input has always different names. It is in the same folder but with different input names.

[hellyars]

Ah, that makes more sense....

It is doable....

You can carry over the filename of the input file as a field and use that field in the output filename.

[hellyars · Accepted solution]

I have a crude approach.  You would need to modify -- again if I understand correctly.

Import the file name and path as a field.

Use a Formula tool to replace .csv with .xlsx.

Use the formula tool again to add the sheetname to the end of the desired file location.

Set the the Output tool to take Table Name from Field set to File Path and File Name...  make sure Option 2 is set to xlsx and Option 3 is set to Overwite Sheet or Range (if you plan to run it a few times).

Input Tool

Formula Tool

•  

Output Tool...

[hellyars · Accepted solution]

@bakaidora 

Just in case that last image of the Output tool configuration got cut off. 

The important part is at the bottom -- where you tell Atleryx what field to use for the path and filename.

[bakaidora]

@hellyarsthanks it was the perfect solution.