Skip to main content
Solved

Move and Rename CSV

  • May 11, 2023
  • 2 replies
  • 47 views

keller
Contributor
Forum|alt.badge.img+7

This may be a little simple but it seems not to work for me, I have a workspace that reads a .csv file and runs a process. Ideally i would like to move this csv file once the process is complete and rename it by date.

What i have tried so far,

After the reader i created a junction and I put one process to run through the whole workspace and another arrow i put to a DateTime stamper, DateTimeConverter and created the attributes filecopy_source_dataset, filecopy_dest_dataset and filecopy_dest_filename, (based on several tutorials i have been reading.) I then use the filecopy writer to move the file. The file gets moved but the name is not changed and i get a warning that --> Ignoring the destination filename .. because the source dataset...was not a file. Destination file names are only used when the source dataset is a file.

For some reason the exact name i did set (@Value(Datum)_@Value(filecopy_dest_filename)) is shown in the written summary but not on the folder, anyone with an idea of how i can approach this?

 

With thanks,

Keller.

Best answer by hkingsbury

I've attached an example of how you could do it :)

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+65
  • Celebrity
  • Best Answer
  • May 12, 2023

I've attached an example of how you could do it :)


keller
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • May 12, 2023

Hey @hkingsbury​ many thanks for the help, it saved the day.