Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Data Type Mapping cheat sheet?

eric_gauthier
5 - Atom

Hello,

 

I am again having trouble loading to a SQL Server table using Alteryx. Does anyone have a cheat sheet that would show compatible data types for mapping purposes? Just looking for a reference table.  

 

e.g. SQL (varchar) = Alteryx (v_String)

SQL (Datetime) = Alteryx (DateTimeNow(dt ...)

 

Many thanks!

 

1 REPLY 1
alexnajm
17 - Castor
17 - Castor

I don't know of a SQL to Alteryx cheat sheet, but the data types help documentation might make it easier to map: Data Types | Alteryx Help

 

This one seems good regarding SQL: SQL Data Types for MySQL, SQL Server, and MS Access (w3schools.com)

Labels