Forum Discussion

lklenner's avatar
lklenner
Frequent Visitor
4 years ago

Table Join with duplicate values need advice

Good morning,   I have a set of data , however, as you would expect when doing a full join, duplicate values are created for missing rows.  The data is correct, but my question is, what is the best...
Need Help
lklenner's avatar
lklenner
Frequent Visitor
4 years ago

Hi v-yingjl 

 

Thanks for your response, however, this does not work.  These are two seperate tables that are being joined, with a different order and rows.  Creating new indices and merging on them does not work.

 

Below is what I'm using at the moment.

 

let
    Source = Table.NestedJoin(MBOMLookup,
      {
        "Component",
        "Component unit",
        "Proj",
        "MBOMData.EBOM"
      },
      EBOMLookup,
      {
        "Component",
        "Component unit",
        "Proj",
        "EBOMData.Immediate Parent"
      },
      "EBOMLookup",
      JoinKind.FullOuter
),