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

Alteryx Designer Desktop Discussions

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

how to do mass change in CSV files

YLYONG
9 - Comet

Hi Alteryx Community,

 

I have a bunch of CSV files of which I need to remove one field from each of them.

All CSV files have the same field and format. 

Is there an efficient way of achieving this?

 

The field I want to remove is "FileName"

 

Thank you all!

 

11 REPLIES 11
Raj
16 - Nebula

use select tool 

Raj_0-1675316623159.png

 

Raj
16 - Nebula

Raj_1-1675316659771.png

 

YLYONG
9 - Comet

@Raj 

 

I have hundreds of these CSV input file, and the output is the individual CSV files

YLYONG
9 - Comet

@Raj thank you 😀

Raj
16 - Nebula

@YLYONG  are you loading them all one by one ?

Pawel_Paleczny
9 - Comet

If you have hundreds of files you can try (of course if they don't have the same structure) create a macro where loop take file one by one and remove file name field.

YLYONG
9 - Comet

@Raj at the moment, yes

Raj
16 - Nebula

To load multiple CSV files directly into Alteryx, you can use the "Input Data" tool and then select the "File" option. From there, you can choose to either select individual files or you can use a wildcard to select all of the files in a directory that match a certain pattern.

For example, if all of your CSV files have the same name pattern, such as "data_*.csv", you can select all of them by specifying the wildcard pattern in the "File" field.

Once you've selected the files, you can then specify how you want the data to be loaded and processed, such as the delimiter, column names, and data types, among others. Finally, connect the "Input Data" tool to the rest of your workflow to process the data as needed.

YLYONG
9 - Comet

@Raj thanks Raj. After removing a field from each of the CSV file, how do I then spit out each of the individual files?

Labels
Top Solution Authors