Create new table from multiple tables

[JSR]

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"

[ManuelBolz · Accepted solution]

Hello

If my post helped you, please give me a 👍kudos and mark this post with Accept as Solution.

Do you mean that?

let
    Source = Table.Combine({Email[[Owner]], Appointment[[Owner]], Lead[[Owner]], Opportunity[[Owner]]}),
    Duplicates = Table.Distinct(Source)
in
    Duplicates

Best regards from Germany
Manuel Bolz

🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github

[JSR]

thanks, i was overcomplicating