CODEWITHSUNDEEP
renamefilenamespentahokettle
Ivan Romanovych
Ivan Romanovych

Reputation: 71

Rename files Pentaho Kettle

Please help! I have lots of pdf files (~6000). Now they are named with uniqueidentifier datatype and located on my PC in folder. In database their names are in column File_ID. There are also columns File_type, First_name, Last_name I need to rename files with new format "First_name Last_name File_type.pdf". I created transformation in PDI and after lookup I have filenames in needed format. But what steps should I use to rename files?

Upvotes: 0

Views: 4368

Answers (2)

Dirk Trilsbeek
Dirk Trilsbeek

Reputation: 6023

one option would be using the move files step within a job, as AlainD suggests. Another option would be to create a batch file (.cmd, or a powershell script) that contains the necessary commands to rename all the files.

Upvotes: 0

AlainD
AlainD

Reputation: 6356

The rename step is at the job level and called Move file.

Upvotes: 2

Related Questions