Forum Discussion

Money's avatar
Money
Icon for Helper I rankHelper I
3 years ago

Assign a value [ID] based on the condition and same value [ID] should not assign again

Hi Team,Help me with the following situation 🙂   Match Conditions 3 1)There are two tables need to match from one ID to another ID based on the condition. In both table these two columns ( Line n...
Need Help
Tips and Tricks
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Did you know you can merge on more than one column?

let
    Source = Table.NestedJoin(#"THOR Data", {"Line Segment", "Track Number"}, #"CWR Data", {"Line Segment", "Track Number"}, "CWR Data", JoinKind.FullOuter),
    #"Expanded CWR Data" = Table.ExpandTableColumn(Source, "CWR Data", {"CWR ID", "CWR MP", "CWR Rail"}, {"CWR ID", "CWR MP", "CWR Rail"})
in
    #"Expanded CWR Data"