Data Type in Alteryx

[rohit782192]

Hey Champs,

What the smarted way to remember all the Data type in Alteryx

[Qiu]

@rohit782192 
Myself always go to this page when I have something not sure about DateTime

https://help.alteryx.com/20214/designer/datetime-functions

[MarqueeCrew]

https://lmgtfy.app/?q=alteryx+data+types+help

@Qiu  And I go to the same place. 

[MarqueeCrew]

as you use the help to get answers, you'll learn features and functionality.  Trial and error works to reinforce your learning. 

cheers,

 mark

[Alteryx_AR]

@rohit782192 - Just write down or take prints and hang infront of your desk.

Cheers

[rohit782192]

How to remember during interview

[atcodedog05]

Hi @rohit782192 

This interactive lesson might help you to get understanding and a way to remember datatype. 

https://community.alteryx.com/t5/Interactive-Lessons/Understanding-Data-Types/ta-p/73958

String Types

1. String (fixed string)

2. V_String (variable string memory-optimized)

3. WString (fixed string which allows Unicode)

4. V_Wstring (variable string memory-optimized which allows Unicode)

So basically 2 distinctive quality is either its fixed or variable length and allows or doesn't allow Unicode

Numeric Types

1. Byte (short number)

2. Int (Int16, Int32, Int 32) (number type without decimal just remember this as int)

3. Float (short number with decimal)

4. Float (long number with decimal)

5. FixedDecimal (user can define digits and decimal digits)

Datetime Types

1. Date (only date)

2. Time (only time)

3. DateTime

Boolean Type: can only be True or False

Spatial Objects: map objects

Most data types are similar to other programming languages. If you remember them as common names/ heading names you will be able to remember subtypes

Hope this helps : )