Hi,
I want to combine data from two postgres databases. I'm able to connect to the two postgres databases individually and run flows (so I know my access is working correctly), but when I try to run the workflows back-to-back, the ODBC connection resets to the latest database and I get two identical sets of data. I've also tried to run the flows in two different workflows, but that didn't work.
What am I doing wrong?
Many thanks
Kirstin
Solved! Go to Solution.
Hi @Kirstin,
Strange; can you create a simple workflow with only two input tools, one that pulls a small query from one ODBC, and the other Input a small query from the other ODBC? If so, then we know Alteryx can pull from both ODBC's in the same workflow, and can mayube try to branch out our reasoning from there, to understand why you would be seeing duplicate data.
Hi John,
I can connect to 2 ODBC's individually, but when I combine the two together, it resets the connection so it looks at the same place twice. I've included my steps below - hoping I've missed something. Thanks for the help!
Fixed now - was simple human error.
Thanks!
Kirstin