Renaming Multiple Dynamic files in Hop

[Cody2590]

I have a scenario where I am downloading multiple dynamic csv files from a server and once I have downloaded them I need to move all those csv files with a specific naming convention.

Say for Eg.

File 1 - 2025_07_17_TechnicalFile
File 2 - 2025_07_17_DataFile
File 3 - 2025_07_17_ErrorFile

So all these files are downloaded on a daily basis in a specific folder say download.
I need these to be moved from download folder to the target location say input folder where I need the names of the files to be as below

File 1 - Technical
File 2 - Data
File 3 - Error

How can we achieve this in Workflow.

[hansva]

You will have to use a pipeline for that

[Cody2590]

Can you explain how the pipeline flow will be??

[hansva]

You download the files to a staging folder with the workflow, in a pipeline you can use the get file names transform to list the content and get separate fields for path and file name. Then you create the new destination file path + name and use a process files transform to do the move.

[dmainou]

Adding to what Hans said above.

Let's assume you have an 'acquisitions' table where your columns are target filename, target location, target extension, etc + final name ... move/copy, load, pipeline to load... etc.
The fields can be populated with hard coded values or REGEX

You then can build a set of assets (workflow's and pipelines) that get the list of all possible things to acquire and pass that down for execution through a loop.
The pipeline inside the loop searches for X (or a regex matching x) on location XX and moves or copies it to location Y name YY.
You may then choose to execute pipeline Z that loads the content of the file into ZZ staging table.

Just a thought...