Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Joining multiple tables with the In-Database tool

akasubi
8 - Asteroid

Hi,

 

I have a single transaction table with a bunch of IDs that needs to be joined with 4 other dimension tables in order to pull data such as product name, market name etc. (joining on id numbers)

 

I'm currently connected to a SQL Server database using the "in-database" tool and would therefore require to use "Join In-DB".

 

What is the best way to go about this?

 

Thanks in advance!

 

afk

2 REPLIES 2
SamDesk
11 - Bolide

Hi @akasubi,

 

It is simply a case of joining one table at a time, so for your 4 tables to join you would have 4 Join In-DB tools one after the other with In-DB Input tools selecting each of the 4 tables to go into one of the join tools.

 

Capture.PNG

It may be easier/quicker to hardcode these joins using a SQL query in a single input tool.

 

Sam :)

akasubi
8 - Asteroid

Hi Sam,

 

Thanks for your prompt reply.

 

Initially I thought of doing it this way but was wondering whether there was a more "efficient" method. But I guess this is the best solution :) .

Labels