Empty values at Left Outer Join

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Empty values at Left Outer Join

      In Transforms, Table Join I do Left Outer join Table 1 and Table 2.
      Table 1: Column1, Column2, #Value
      Table 2: Column1, Column2, ValueDouble

      I need Table3 Column1, Column2, #Value, ValueDouble.

      But I receive Empty values from Table 1 and fill values from Table2.

      For example:
      Table1:
      one, oneString, 5
      two, twoString, 6

      Table2:
      one, oneString, 7

      Result:
      one, oneString, 5, 7
      empty, empty, 6

      Why the system loses values two and two string?

      The post was edited 1 time, last by Viverna ().