Data type problem after a join

[Dupuy]

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.

[ShankerV]

Hi @Dupuy 

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

[Dupuy]

Hi @ShankerV 

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. 

[ShankerV]

Hi @Dupuy 

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

Will be easy to check.

Many thanks

Shanker V

[Deano478]

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

[FinnCharlton · Accepted solution]

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.

[Dupuy]

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 !