Input name --> Output name
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I missed to mention the the input has always different names. It is in the same folder but with different input names.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@hellyarsthanks it was the perfect solution.