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.
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:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Data-type-String-V-String-V-WString-amp-WString-Comparison-and/td-p/593117
Regards
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:
15 decimal places
https://help.alteryx.com/current/designer/data-types
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
