Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Macro wrongly converting decimal seperator

Hamder83
11 - Bolide

Hi 

Im using an alteryx xlsx to csv converter, which converts , to . in the output.

Any way to change this ?

Using this macro 


kind regards

10 REPLIES 10
DavidP
17 - Castor
17 - Castor

I think there must be a localisation issue with the Microsoft Excel driver that Alteryx uses, or perhaps you customized the settings on your Excel version? As you can see, the data loaded with the Input data tool shows dots instead of commas.

 

I don't know a way around this other than to change the dots to commas once the data is loaded as shown in the previous example I attached.

 

DavidP_0-1589276220096.png

 

Labels