Joining multiple tables with the In-Database tool

[akasubi]

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

[SamDesk · Accepted solution]

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.

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

Sam :)

[akasubi]

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 :) .