Data type problem after a join

Hello,

Before my join I have my field "Rotation quotidienne" in float number:

Then after my join, while I put the field in "double" type. However, I have only integers in the column "Rotation Quotidienne":

Do you know why? Thanks in advance for your help.

Workflow

Tips and Tricks

Common Use Cases

Join

Data Investigation

Accepted answers

Hi @Dupuy, @Deano478 is right, using commas as your decimal separator is causing some field conversion issues. Try using a formula tool and the 'ToNumber' function instead. Here you can tell Alteryx that the decimal separator is a comma. You could also use a Multi-Field Formula tool to change all of your numeric fields at once.

Conversion Error with commas.yxmd

All comments

I see there are summarize tool and formula tool before the Join.

Not sure what action has been taken there.

There might be some summarize done and the same would have been saved as INT16 or 32.

Then changing to double will not get back the decimal's.

Many thanks

Shanker V

Thanks, I tried to put a select tool before summarize tool and formula tool.

And I'have something strange, In the input of the select tool i'have float in my colomne "rotation quotidienne" :

In the output of the select tool i'have integers in my colomne "rotation quotidienne" :

Thanks in advance.

Can you please share the workflow or mock the data's and share the workflow.

Will be easy to check.

Many thanks

Shanker V

Hey @Dupuy I have a feeling it has something to do with those commas in the numbers

Hi @Dupuy, @Deano478 is right, using commas as your decimal separator is causing some field conversion issues. Try using a formula tool and the 'ToNumber' function instead. Here you can tell Alteryx that the decimal separator is a comma. You could also use a Multi-Field Formula tool to change all of your numeric fields at once.

Conversion Error with commas.yxmd

Hi @ShankerV @FinnCharlton @Deano478 ,

Yes the problem was the commas. Thanks now it's working.

In France we use commas and not point for float 😣😂

Thanks !

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703