Hey!
I'm new to alteryx as well but not to SQL.
Challenge: So am trying to lookup a table in MySql database based on some conditions which can be pulled into alteryx workflow where I have few unstructured data from different sources to be compared with.
Explaining what I see: The SQL that I use returns close to 21000 records based on the where clause in my MySql client. I can preview the select statement in the configuration window where it lists the top 100 records.
Problem: As the tables are too big to be read every time, I have a query with conditions in where clause to the input tool(ODBC set and working fine) at the config window and execute the WF, I can get only the first record to be displayed in the browse window. It returns only 1 record.
Required: The SQL should retrieve all records for the query used so I can compare/lookup the results for further processing.
TIP: I'm looking for a source qualifier tool as in other ETL tools like Informatica where the SQL will fetch all records for that query.
Can you help please?
PS: I have already tried using dynamic input tool as suggested in other threads. no luck. An example would greatly help.
