Forum Discussion
Running Python Script Changes Types and Adds Additional Zeros
Hello everyone.
I am running a python script and I have realized that even when my script is empty, after running it the following problem occurs:
Power Query changes text types to decimal and this type changing results in an additional zero.
This is the column before running the script:
This is it after running the script:
In my applied steps, after running the script, there is a "Changed Type" step, when I remove it the numbers go to this:
why is this happening?
can someone help me?
Thanks in advance.
Sincerely
Seems to be a locale mismatch. Some cultures use a dot as the decimal separator while others use a comma. Make sure your culture settings match between Power Query and Python.
1 Reply
- lbendlinSuper User
Seems to be a locale mismatch. Some cultures use a dot as the decimal separator while others use a comma. Make sure your culture settings match between Power Query and Python.