Double type not showing numeric seperator

Question

Hi

I am very new to Alteryx and just working thru a case study in my training. However, I have fallen at the first hurdle when trying to ensure the data type is numeric. I have followed the instructions and per the attached I configured the relevant field to double, but the results are not showing the number with a numeric separator and when I tried to click the 000 to update this it is greyed out and not bold like it was in the video I was watching. This is preventing me from moving on to the next step as the join will not work. Does anyone know if there is a setting I need to change in the background or what else could be causing this? Thank you

Double type issue.PNG

OTrieger · Answer

Hello @Carlyn

May I asked what is the format of your number flowing for the excel file, American 100.50 or European 100,50? I assume that the values are in European format other wise Alteryx would automatically assign Numeric data type for that field, but you got it as a string. This is my assumption, but I might be wrong.

If your excel containing the later, European format, the minute that you will change the data type to Double it will remove all the values post the coma, in other words you will lose all your decimals. If that is the case you will need first to replace the coma with period so your data will be in a numeric format supported by Alteryx. Alteryx does not understand coma as a delimiter for numbers, only period for the decimals.

Ankur_BDO · Answer

In the results windows you will notice three zeros (sample 000) icon. Click this icon to see the values in results window with comma separator. Maximize the image to see the screen shot top right corner.

Deano478 · Answer

@Carlyn if your just doing simple calcs then the numeric separators like commas should make no difference to the result