3/7/2024 0 Comments Expert choice v11 EXEL![]() ![]() You'll need this because the Dynamic Input does some modifications to this string ![]() Leave the Query the way it is, "Select * from _TableName_". You'll need to change the connection to connect to your actual DB. The Dynamic Input tool is configured like this This particular macro uses the control parameter to replace the tablename that's in the Text Input tool. The batch macro will run once for every record that's passed in to the control parameter, but the runs will be completely independent. To get around this, you'll need to use a batch macro. This is because Alteryx will read data from multiple tables in a standard workflow, but as soon the schema differs from the 1st table, the input tool will skip the table. As to in his post, if the schema of the tables are different, which is the case in every SQL data database, you can't use a standard workflow to extract the data. Hi a workflow that will connect to any SQL database, extract the data from a list of tables and write the results to separate sheets in an excel workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |