Input name --> Output name

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.

Output

Accepted answers

hellyars

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

@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.

All comments

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

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.

Input Tool

Formula Tool

Output Tool...

hellyars

@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.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335