In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

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

andersonamaral
5 - Atom

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!

3 REPLIES 3
vizAlter
12 - Quasar

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)

 

vizAlter_0-1599775216828.png

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

CharlieS
17 - Castor
17 - Castor

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
5 - Atom

@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!

Labels
Top Solution Authors