In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Load Multiple Alteryx Databases with Different Schemas

mariahmeehan
7 - Meteor

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.

2 REPLIES 2
JoBen
11 - Bolide

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

Harbinger
9 - Comet
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.
Labels
Top Solution Authors