Input data returning single row

Input data workflow returns single row. There is no limit set. It is ODBC database connection and the query works perfectly in MySql.

Workflow

Input

Accepted answers

BrandonB

Happy to help! As reference, here is the MySQL data source page: https://help.alteryx.com/current/DataSources/MySQL.htm

The drivers we currently support are

ODBC client version 5.01.04.00, 5.01.12.00
ODBC client version 5.02.06.00, ANSI and Unicode® encoding (Spatial support)

I normally check my query first alongside my driver just to double check everything is good to go

All comments

BrandonB

Can you try adding a browse tool afterwards? It could just be the data preview on the anchor of the tool. Add a browse tool and run it again to represent all of the data if it is over 1MB.

Puru

Thanks Brandon

Already tried that. The Browse tool also shows single record in it.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703