Forum Discussion

vfernandes0408's avatar
vfernandes0408
Frequent Visitor
8 years ago
Solved

Aggregate Value Another Table

Hi, i need aggregate two table. I need get value on table 2 if dont exist information on table 1 and mount table 3 with aggregate values   https://photos.app.goo.gl/zGldGWhb8uN8erYf1
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi vfernandes0408

    Something like that?

    Here is the code for this:

    let
    Source = Table.NestedJoin(Table1,{"Date"},Table2,{"Date"},"Tabelle2",JoinKind.LeftOuter),
    #"Expanded {0}" = Table.ExpandTableColumn(Source, "Tabelle2", {"Date", "Value", "Type"}, {"Tabelle2.Date", "Tabelle2.Value", "Tabelle2.Type"}),
    #"Added Custom" = Table.AddColumn(#"Expanded {0}", "Table", each if [Tabelle2.Date] = null then "Table1" else "Table2"),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Date", "Value", "Table"})
in
    #"Removed Other Columns"
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi vfernandes0408

Something like that?

Here is the code for this:

let
    Source = Table.NestedJoin(Table1,{"Date"},Table2,{"Date"},"Tabelle2",JoinKind.LeftOuter),
    #"Expanded {0}" = Table.ExpandTableColumn(Source, "Tabelle2", {"Date", "Value", "Type"}, {"Tabelle2.Date", "Tabelle2.Value", "Tabelle2.Type"}),
    #"Added Custom" = Table.AddColumn(#"Expanded {0}", "Table", each if [Tabelle2.Date] = null then "Table1" else "Table2"),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Date", "Value", "Table"})
in
    #"Removed Other Columns"
vfernandes0408's avatar
vfernandes0408
Frequent Visitor
8 years ago

thanks a lot.

I find some errors but i correct and now works fine