Field type proposition

[simonaubert_bd]

Hello,

Unless you're lucky, your input dataset can have fields with the wrong types. That can lead to several issues such as :
-performance (a string is waaaaaaaay slower than let's say a boolean)
-compliance with master data management
-functional understanding (e.g : if i have a field called "modified" typed as string, I don't know if it contains the modification date, an information about the modification, etc... while if it's is typed as date, I already know it's a date)
-ability to do some type-specific operations (you can't multiply a string or extract a week from a string)

right now, the existing tools have been focused on strings but I think we can do better.

Here a proposition :

entry : a dataframe
configuration :
-selection of fields
or
-selection of field types
-ability to do it on a sample (optional)

Algo :

Alteryx	Byte	bool	only 2 values. 0 and 1	to be done
Alteryx	Int16	bool	only 2 values. 0 and 1	to be done
Alteryx	Int16	Byte	min=>0, max <=255	to be done
Alteryx	Int32	bool	only 2 values. 0 and 1	to be done
Alteryx	Int32	Byte	min>=0, max <=255	to be done
Alteryx	Int32	Int16	min>=-32,768, max <=32,767	to be done
Alteryx	Int64	bool	only 2 values. 0 and 1	to be done
Alteryx	Int64	Byte	min>=0, max <=255	to be done
Alteryx	Int64	Int16	min>=-32,768, max <=32,767	to be done
Alteryx	Int64	Int32	min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	Fixed Decimal	bool	only 2 values. 0 and 1	to be done
Alteryx	Fixed Decimal	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	Fixed Decimal	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	Fixed Decimal	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	Fixed Decimal	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	Float	bool	only 2 values. 0 and 1 or 0,-1	to be done
Alteryx	Float	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	Float	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	Float	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	Float	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	Float	Fixed Decimal	to be done	to be done
Alteryx	Double	bool	only 2 values. 0 and 1 or 0,-1	to be done
Alteryx	Double	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	Double	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	Double	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	Double	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	Double	Fixed Decimal	to be done	to be done
Alteryx	Double	Float	when no need for doube precision	to be done
Alteryx	DateTime	Date	no hours, minutes, seconds	to be done
Alteryx	String	bool	only 2 values. 0 and 1 or 0,-1 or True/False or TRUE/FALSE or equivalent in some languages such as VRAI/FAUX, Vrai/Faux	to be done
Alteryx	String	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	String	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	String	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	String	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	String	Fixed Decimal	to be done	to be done
Alteryx	String	Float	when no need for doube precision	to be done
Alteryx	String	Double	when need for double precision	to be done
Alteryx	String	Date	test on several date formats	to be done
Alteryx	String	Time	test on several time formats	to be done
Alteryx	String	DateTime	test on several datetime formats	to be done
Alteryx	WString	bool	only 2 values. 0 and 1 or 0,-1 or True/False or TRUE/FALSE or equivalent in some languages such as VRAI/FAUX, Vrai/Faux	to be done
Alteryx	WString	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	WString	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	WString	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	WString	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	WString	Fixed Decimal	to be done	to be done
Alteryx	WString	Float	when no need for doube precision	to be done
Alteryx	WString	Double	when need for double precision	to be done
Alteryx	WString	String	Latin-1 character only	to be done
Alteryx	WString	Date	test on several date formats	to be done
Alteryx	WString	Time	test on several time formats	to be done
Alteryx	WString	DateTime	test on several datetime formats	to be done
Alteryx	V_String	bool	only 2 values. 0 and 1 or 0,-1 or True/False or TRUE/FALSE or equivalent in some languages such as VRAI/FAUX, Vrai/Faux	to be done
Alteryx	V_String	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	V_String	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	V_String	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	V_String	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	V_String	Fixed Decimal	to be done	to be done
Alteryx	V_String	Float	when no need for doube precision	to be done
Alteryx	V_String	Double	when need for double precision	to be done
Alteryx	V_String	String	Same length	to be done
Alteryx	V_String	Date	test on several date formats	to be done
Alteryx	V_String	Time	test on several time formats	to be done
Alteryx	V_String	DateTime	test on several datetime formats	to be done
Alteryx	V_WString	bool	only 2 values. 0 and 1 or 0,-1 or True/False or TRUE/FALSE or equivalent in some languages such as VRAI/FAUX, Vrai/Faux	to be done
Alteryx	V_WString	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	V_WString	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	V_WString	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	V_WString	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	V_WString	Fixed Decimal	to be done	to be done
Alteryx	V_WString	Float	when no need for doube precision	to be done
Alteryx	V_WString	Double	when need for double precision	to be done
Alteryx	V_WString	String	Same length,latin- character only	to be done
Alteryx	V_WString	WString	Same length	to be done
Alteryx	V_WString	V_String	latin- character only	to be done
Alteryx	V_WString	Date	test on several date formats	to be done
Alteryx	V_WString	Time	test on several time formats	to be done
Alteryx	V_WString	DateTime	test on several datetime formats	to be done

The output would be something like that

Field	Input type	Proposition	Conversion
toto	float	int	formula (with example)/native tool/datetime conversion tool…

Best regards,

Simon