Creating a join from a lookup table

Stan_Smith
Stan_Smith Member
edited March 2023 in SQL DataFlows

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?

Comments

  • mhouston
    mhouston Contributor
    edited April 2022

    @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.

  • 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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**