Input Tool - How to change default delimiter for .csv files?

[andersonamaral]

Hi!

Is there any way to change the the Input tool default delimiter from , to ; ?

I have dozens  of .csv files that have columns delimited by semicolons and I need to load then into a model.

Thx!

[vizAlter · Accepted solution]

Hi @andersonamaral — Try to update the values as the screenshot below:

1) If you want to import more than 1 CSV file then use \*.csv in the last. Make sure each file has the same layout.

2) You can change/put the delimiter at Option#5 (Delimiter row)

3) It will add a new column and display the file name (not a mandatory selection)

If this solves your issue please mark the answer as "Solved" with a Like, if not let me know!

[CharlieS]

Unfortunately we can't change tool default settings.

However, depending on the data/files we have other options with Alteryx to make things easier. If the files have the same schema and you want to union them all, you could use a single Input tool using the wildcard method, then there's only one delimiter setting to change like @vizAlter demonstrated. Otherwise a batch macro or XML editing could be your friend. 

[andersonamaral]

@vizAlter 

The moment I've read your answer the very first Alteryx tutorial I've followed came back to my memory ... it was one of the initial tips the instructor gave 😛

Well, It did the trick.

Thank you very much!