Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.
hi @Pang_Hee_Choy thanks for the feedback! Unfortunately, numeric types cannot contain string characters. If you want to physically see the comma separator in the results grid for the numeric field, you can use the ToNumber() function with the new toggle, but it won't actually have the comma separator in the data field itself.
We'll be sure to pass this along to our product management team as soon as the necessary criteria are met.
i just ran into this issue today. i needed to use a formula tool with the "tonumber()" function before the select tool because alteryx wouldn't recognise the number field if the commas were there.. the select tool should be able to recognise a number that contains comma separators