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

Alteryx Designer Desktop Discussions

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

Dynamic Input In-DB Tool Issues

suppahc
7 - Meteor

So I'm testing performance and I'm having issues with the In-DB portion. I was able to run everything and it took 1.5 hours in total without using any In-DB tools. Now I'm trying to do a portion of the work In-DB and see if it cuts down on runtime.

 

I'm getting an error for a join: left and right side must have the same in-db connection.

 

My left input to the join comes from a dynamic input tool where the connection is New Server.

 

My right input to the join is a local file I'm using data stream in and creating a temporary file with the connection name new server. I've tried to rename it so that its New Server and still getting issues with this error.

1 REPLY 1
suppahc
7 - Meteor

So it appears that it is case sensitive. Didn't realizing my Dynamic Input In-DB name was all caps. Once I fixed that it worked.

Labels