Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

V_string Vs Double

SH_94
11 - Bolide

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.

 

Jacob_94_0-1614762704530.png

 

8 REPLIES 8
Emil_Kos
17 - Castor
17 - Castor

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
11 - Bolide

Hi @Emil_Kos

 

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

Jacob_94_0-1614763223264.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi @SH_94,

 

Sure. It should work now: 

 

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

 

 

SH_94
11 - Bolide

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.

Jacob_94_0-1614763920608.png

 

afv2688
16 - Nebula
16 - Nebula

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
17 - Castor
17 - Castor

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
8 - Asteroid

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
16 - Nebula
16 - Nebula

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:

 

float4 byte-3.4E-38 to 3.4E+386 decimal places
double8 byte-1.7E-308 to 1.7E+308

15 decimal places

 

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

 

Regards

Labels