Alteryx designer Discussions

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

Dynamic Input Tool: The file "" has a different schema than the 1st file in the set.

Highlighted
Meteor

Did you solve this?

Highlighted

Here is a link to article that I got all my knowledge from:

 Alteryx-Knowledge-Base /Read-in-Multiple-Excel-Files-with-Multiple-Tabs-that-have 

Highlighted
Asteroid

That was my original question.  While the OP appears to be still around, he never responded past May of 2018 which was also his last post to the forum.  He's the only one that can mark this as Solved and we don't know what his resolution was.

Highlighted

Your Macro needs to be "Batch" and not "Standard".

 

In the Input tool, a query just looks like a file to the Tool.

 

Create the Input tool, with the Database connection to one of the tables.

 

With the Action Tool modify the field called "File" and replace the hole thing "aka:Database Connection|||Select ..." with your new value of the Database Connection between "|||" it and your SQL.

 

Or just modify the specific string you want change on the bottom of the Configuration and replace

like the "FROM TABLE" with "FROM  TABLE2" and so on, when your select statement is like "Select *"

Labels