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!
use select tool
@Raj thank you 😀
@YLYONG are you loading them all one by one ?
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.
@Raj at the moment, yes
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.
@Raj thanks Raj. After removing a field from each of the CSV file, how do I then spit out each of the individual files?
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |