Solved! Go to Solution.
Hi Michael,
There are of course several ways to do this and I'm not sure if there is a BP. So... I'll tell you how I would do it.
If you have the In-DB tools enabled, then you can just use a Connect In-DB tool to connect to each table and a Join In-DB tool selecting Left-Outer Join as such:
Without the In-DB tools each time you Join, you'll have a Union tool afterwards to Union the output from the L & J outputs like in the below screenshot.
Once you have layed out your 12 tables and selected the field that each join is performed on, you can put all this in a container and minimise it if you like as you won't need to reconfigure these again. Then the start of your flow will look something like this:
Otherwise you can use the SQL Editor on 1 input tool, however that then involves a script rather than point & click.
Kane
I wish I could see your 2nd and 3rd screenshots (no preview or ability to view image with right-click) because I've been curious about this too... sort of replicating the way Tableau considers multiple tables in an Access database as one data source.