Looking for some help on the issue below. Data source export is in the first column, which contains numbers with commas and is coming into Alteryx as VString. Normally, I just use the select tool and change to double or a number. In this instance, Alteryx is taking the first two numbers before the comma and dropping the rest.
Do i have to just find replace the comma to fix? or is there an alternative solution? thanks
Source | Alteryx Workflow |
vstring | double |
Pmt Amt | Pmt Amt |
25,500.00 | 25 |
108.33 | 108.33 |
26,350.00 | 26 |
26,350.00 | 26 |
24,650.00 | 24 |
108.33 | 108.33 |
80 | 80 |
Solved! Go to Solution.
@kubikbr you need to remove the ',' from the amount field to convert it into double
binuacs - this approach is still converting negative numbers in the large dataset to 0, which is overstating the column total.
thank you both for your help on this