Load data in multiple tables in one go

[Vikas038]

Hi Team,

Business requirement - As a standard process, based on a short sql code, simple we need to pull data from one table and load in another table. And same process needs to do for around 70 tables.

Please suggest best way to automate this to avoid manual effort.

[gabrielvilella]

You can automate this process using a batch macro. There is this great article to get you started on this topic:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...