This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Whenever I use the Summarize In-DB tool, the decimal precision of my fields changes (increases). This is an issue for me as I need to load this data into SQL Server but the precision is too high for SQL Server. To resolve this, I've had to use a formula tool to convert/cast each field and change the decimal precision.
Currently, the number of fields I have is relatively small but I can see this being a big problem should the number of fields significantly increase as I need to do this individually.
Does anyone know how I can prevent Alteryx from doing this? Would really help my situation.
I don't have a recommendation to stop the Summarize tool from changing precision, but you can use a Multi-Field formula to dynamically change data types if your precision is consistent across multiple fields.
If the precision is not consistent, there are some methods using a CReW macro that I can share as well which should help.