Forum Discussion
JSR
2 years agoHelper II
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"
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
2 Replies
- ManuelBolzResponsive Resident
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- JSRHelper II
thanks, i was overcomplicating