Forum Discussion

DiKi-I's avatar
DiKi-I
Post Partisan
2 years ago

Power query help

Hi , I have multiple relationship table around 5 to 6 which are available in mutiple tables. I'm attaching some sample data there are 3 tables table1, table2, table3. Realtionship is from parent...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

let
    Table1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Table2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Table3 = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    Custom1 = Table.Combine(List.Transform(List.Accumulate({Table1,Table2,Table3},null,(x,y)=>let a=Table.ToRows(y) in if x=null then a else List.TransformMany(x,each let b=List.Select(a,(x)=>List.FirstN(x,2)=List.LastN(_,2)) in if b={} then {{null,null}} else b,(x,y)=>x&List.LastN(y,2))),each let a=List.RemoveNulls(_) in #table(List.Alternate(a,1,1),{List.Alternate(a,1,1,1)})))
in
    Custom1