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

Missing Data from MYSQL query (Input Data tool)

DaveJ
7 - Meteor

Hello,

 

I have the weirdest problem. I'm pulling in a 2 column table of exactly 50 rows (US state codes and names). When I query the MYSQL Database table the data is all present and intact. When I connect to the table using the Input Data tool there are loads of nulls where there should state codes, state names or both. What on earth is causing this?

 

I tried searching for the problem but found nothing useful. Any ideas good people of the Alteryx Community?

 

Regards

David

1 REPLY 1
DaveJ
7 - Meteor

Update: I have recreated the ODBC connection using this driver (MySQL ODBC 5.3) and it now works. I had been using this driver (Maria DB ODBC 2.0) - It is a Maria Database technically hence the driver I had been using.

 

 

Labels