Forum Discussion

JSR's avatar
JSR
Helper II
2 years ago
Solved

Create new table from multiple tables

Hi,

 

Having 4 similar tables as:

 

What can I do to have a new table with Only unique Owners names?

 

I'm creating it like this, but it doesnt show all users.

 

let
    Source = Table.NestedJoin(email, {"owneridname"}, appointment, {"owneridname"}, "appointment", JoinKind.FullOuter),
    #"Merged Queries" = Table.NestedJoin(Source, {"owneridname"}, phonecall, {"owneridname"}, "phonecall", JoinKind.FullOuter),
    #"Removed Other Columns" = Table.SelectColumns(#"Merged Queries",{"owneridname"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns"),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"owneridname", "Name"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Name] <> null and [Name] <> "Power Platform Admin Admin"))
in
    #"Filtered Rows"

 

 

 

2 Replies