Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

Join In DB

vishnusai0908
6 - Meteoroid

Hello All,

 

I am Getting the below error, While Joining the data between two different DB, We have any chance to join the data between two Different DB.

 

Join In-DB (14) The left and right side must have the same In-Db connection. 

4 REPLIES 4
alexnajm
17 - Castor
17 - Castor

Correct - with In-DB they have to be in the same database! You cannot do this unless you Data Stream Out of one database and Data Stream In to the other.

alexnajm
17 - Castor
17 - Castor

The other option is to just use regular Input Data tools!

vishnusai0908
6 - Meteoroid

We need to use the Data Stream out, After that we need to join, But the Major Issue is the data is having Huge number of rows.

alexnajm
17 - Castor
17 - Castor

I'm sorry then, but those are your options for In-DB processing!