V_string Vs Double

[SH_94]

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.

[Emil_Kos]

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:

https://help.alteryx.com/current/designer/data-types 

[SH_94]

Hi @Emil_Kos

Can you share with me the link again as it show as below 

[Emil_Kos]

Hi @SH_94,

Sure. It should work now: 

https://help.alteryx.com/current/designer/data-types

[SH_94]

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.

[afv2688 · Accepted solution]

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-am...

Regards

[Emil_Kos]

Hi @SH_94,

If your number is integer without decimal places you can store really big numbers as Int 64. 

I don't think you can change the seize of the double but maybe @afv2688 may know a way how to achieve it 😀

[Deba93]

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

[afv2688 · Accepted solution]

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