I have changed those data presented in amount under the field type to Double and it show the pink colour as below.
Can anyone explain when we should we V-string and when we should select double instead.
Solved! Go to Solution.
Hi @SH_94,
Basically, the V-string is for text columns and double is a format dedicated to numbers.
If you want to learn more about data types in Alteryx I would suggest visiting this page:
Hi @Emil_Kos
Can you share with me the link again as it show as below
Hi @ Emil_Kos
Thanks for the link shared.
May i know if we can change the size for this particular field. As you can see, the some of the size is 8 and others are 300.
Hello Jacob,
Double is a numeric data type. Meaning that you are able to perform calculations and operaions with them (sum, multiplication etc).
On the other hand, V_strings are text data types, meaning that everything you type in them will be managed as a text (even if it is a number).
Here is a basic explanation:
Regards
Hi,
As others have rightfully mentioned it depends on the datatype. V_String is used for texts and Double is used numeric data types. Double uses 8 bytes and can represent values in the range - 1.7 * 10 ^-308 to 1.7 * 10 ^308.
https://help.alteryx.com/current/designer/data-types
You can use the link to understand it better.
Thanks & Regards,
Deba
Hello @SH_94 ,
Double data size cannot be changed. If you want to decrease it you may use float. Here is a table with the basic sizes of the two data types:
float | 4 byte | -3.4E-38 to 3.4E+38 | 6 decimal places |
double | 8 byte | -1.7E-308 to 1.7E+308 | 15 decimal places |
https://help.alteryx.com/current/designer/data-types
Regards