Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

File Name Renaming - Folder

Punit_Kapadia
7 - Meteor

I have a about 300 csv files in the folder. 

 

Need to rename all fields based on the field criteria. 

 

While i have a workflow to create a new output file can be created to derieve name from the field individually.

 

Is there to have the workflow run across all the 300 files than running it for each csv individually? 

5 REPLIES 5
Raj
16 - Nebula

@Punit_Kapadia 
using Run command tool this can be achieved.

Raj
16 - Nebula

@Punit_Kapadia 
please find the attached workflow for reference

Mark done if solved.

Punit_Kapadia
7 - Meteor

Thanks!

Punit_Kapadia
7 - Meteor

@Raj : Just to clarify how does CMD work if the name of the file is to be derieved from a field in it. 

 

e.g. File 1

 

DateOrder No
01-June-2410001

 

Renamed File: 10001-01-June-24 

File 2

 

DateOrder No
01-June-2410002

 

Renamed File: 1002-01-June-24

Raj
16 - Nebula

@Punit_Kapadia 
you will be required to use a formula tool where first you will be creating a new file name based on the fields

and then while creating the command use the newly created file name and this will work perfectly.

Labels