Data Type

Question 1

Int16/32/64

Answer 1

refers to integer data types with different bit sizes

Question 2

Float/Double

Answer 2

floating data types used for representing decimal numbers (float - 7/double-15)

Question 3

Fixed decimals

Answer 3

used for representing decimal numbers with fixed number of digits after the decimal point (255.2)

Question 4

Fixed length strength

Answer 4

predertermined length

Question 5

V_string

Answer 5

stores strings of varying lengths

Question 6

Date/Time

Answer 6

allows calculations with date/time
date - YYYY-MM-DD
date time: YYYY-MM-DD HH:MM:SS
time: HH:MM:SS

Question 7

The input for task 1 contains a list of numbers (formatted as V_String when input into the workflow). All record have 4 digits to the left of the decimal, and some of the records start with a leading zero. To the right of the decimal, there are a varying number of digits (1-5 digits)

Which of the following data types would keep all four digits to the of the decimals and keep only one digit to the right of the decimal?

Answer 7

string

Question 8

In Alteryx, what happens when you format a string field as an INT64 data type

Answer 8

non-numeric characters are automatically removed, and a conversion error is indicated.

Question 9

Which Alteryx tool can remove leading zeros from a text field while keeping it as a string data type?

Answer 9

FORMULA too, but not SELECT tool (create formula with TRIM function)