Creating a join from a lookup table

Stan_Smith · 2022-04-25T21:09:41+00:00

There was an error rendering this rich post.

I have created a dataflow that joins two sets of data together, however when i join them together it's dropping data because it doesn't have anything to match with. How would i create a dataflow that would match all the data and any of the unmatched records would also stay?

Find more posts tagged with

SQL

Magic ETL

Data Flows

Comments

mhouston

@Stan_Smith it sounds like you need to use a full outer join - this will find the matches between dataset 1 and dataset 2, but will also keep any unmatched records from dataset 1 and any unmatched records from dataset 2.

GrantSmith

You can search for SQL JOINs to understand the different types of joins. https://mindmajix.com/joins-sql-server has a good infographic outlining how the different join types work that you can apply in your dataflow.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of