This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm using the dynamic input tool to dynamically change the where clause run in a SQL statement.
So essentially I have a bunch of where clauses in a single field in a single table, and then the dynamic input tool is meant to swap out the where clause for each row, run that query and return the result.
The problem i am having is that Alteryx is giving me this error for each alternate row: Error: Dynamic Input (11): The file "" has a different schema than the 1st file in the set.
So it runs a query, complains about a row, runs the next query, complains about the next row and so on.
I would understand if i was actually reading from multiple files, but i'm not, my source is a single table.
I've even changed my source file to from XLS to a sql server table to a cvs, same issue every time.
I've watched a tutorial on Batch Macro's. However, I've tried unsuccessfully to put this into a Macro.
I'm using SQL Query and updating the tables name via a list.
All of the Macro posts I've seen reference an Excel or CSV input.
Also, is it referring to my SQL schema? Because all of the tables in my query are mine.
This works fine on some, but not all. I even export all of the columns with their data types, sorted them and tried running in groups. Groups with the same amount of columns and data types still produced this error.
In the "Input Tool" the internal value of File as seen within the Action Tool Configuration Window, with the "Input" Tool instead of "Dynamic Input" tool you can make your own Dynamic Input tool.
As the "Dynamic Input" tool is great a dynamic updating the single query to anything you want.
But the "Action" tool on Top of the "Input" tool in Macro changes everything so can change the database connection and the query, and with multiple queries it isolates the schema changes on your different table queries.
Internally the "Input" tools stores you different file and data connections in a common way as show next.
Excel File value is like: MyExcel.xlsx|||MySheetName
Database File value is like: aka:DBConnection|||Select * from table