Forum Discussion
Merge two tables and avoid duplicates
Hello, I have the following two tables and i am trying to create a new table in Power Query - merge and keep only the rows in the Reference table which are not found in the Exceptions table. Please ...
let Source = Table.NestedJoin(reftab, {"Student Name"}, exctab, {"Student name"}, "exctab", JoinKind.LeftOuter), #"Lowercased Text" = Table.TransformColumns(Source,{{"exctab", each Text.Combine([Reason],", "), type text}}) in #"Lowercased Text"
Hi Anonymous ,
you can expand the "Reason"-column from the merged table.
But you have to decide how to deal with multiple different entries for one student: Do you only want to keep the first/last or even concatenate them?