ignoring decimals after using summarize tool

Question

Hi all,

I am struggling with an issue in Alteryx.

I have numbers that are decimals but after using summarize tool, Alteryx removes "commas" and joins numbers together. for example, I have 15911.9 and after summarizing I have 159119 or Alteryx adding 0 so I have the number 159110. I tried as well double, float, fixed decimals, and regex but nothing resolved this issue. I also tried in select tool click on use commas as decimal separators but nothing helped.

could you please help me with some advice on what can be wrong?

thank you

Katarina

jdminton · Answer

Hi @Kate13122 ! Alteryx cannot process numbers with commas, so I'm guessing that you are doing something to cleanse the numbers prior to the summarize tool. You may be doing this as part of regex or using the data cleansing tool. If you have the data cleansing tool in your workflow, look for the highlighted box below.

If you have numbers with commas, use a formula tool to replace the commas like this before using the select tool to convert with number:

If these don't solve your issue, please provide at least an image of your workflow so we can help.

FinnCharlton · Answer

Hi @Kate13122 , if you could share some sample data or sample workflow that shows this problem it would really help us figure it out. Cheers