topic Re: Load Multiple Alteryx Databases with Different Schemas in Alteryx Designer Desktop Discussions

Load Multiple Alteryx Databases with Different Schemas

mariahmeehan — Mon, 28 Jan 2019 17:22:16 GMT

I have multiple Alteryx Databases that I need to load and apply the same logic to however some of the schemas are different then the others. I know there are macros out there to do this for Excel but I have not been able to find any information on how to do this with Alteryx dbs. Any help is appreciated.

Re: Load Multiple Alteryx Databases with Different Schemas

JoBen — Mon, 28 Jan 2019 19:26:23 GMT

Hi @mariahmeehan, could you maybe more specific with your problem? Is there a workflow or a picture of your workflow that you could attach?

Re: Load Multiple Alteryx Databases with Different Schemas

Harbinger — Wed, 30 Jan 2019 03:50:38 GMT

This sounds like a perfect place for a batch macro. What you’re most likely referencing with the excel macros will be the same logic you’d use to write the yxdb’s. The changing schema is the tricky part not the output :) I encourage you to download those macros and simply try to replicate the logic but with yxdb output.