Forum Discussion

TheNicholas27's avatar
TheNicholas27
New Member
2 years ago

Require assistance for comparing multiple columns

Greetings,   I have been trying to find any kind of help regarding a task im trying to accomplish.   The task goes like this.   I have 3 columns, 1 with numbers that are attributed to students...
Need Help
ManuelBolz's avatar
ManuelBolz
Responsive Resident
2 years ago

Hello

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

i hope the following code helps you.

 

let
    Quelle = Table.FromRecords({
        [StudentNumber = 101, StudentName = "Alice", TestTakenBy = "Eva"],
        [StudentNumber = 102, StudentName = "Bob", TestTakenBy = "Charlie"],
        [StudentNumber = 103, StudentName = "Charlie", TestTakenBy = "Bob"],
        [StudentNumber = 104, StudentName = "David", TestTakenBy = "Alice"],
        [StudentNumber = 105, StudentName = "Eva", TestTakenBy = "Charlie"]
    }),
    Type = Table.TransformColumnTypes(Quelle,{{"StudentNumber", Int64.Type}, {"StudentName", type text}, {"TestTakenBy", type text}}),
    Students = Type[[StudentNumber],[StudentName]],
    Merge = Table.NestedJoin(Type, {"TestTakenBy"}, Students, {"StudentName"}, "Test", JoinKind.LeftOuter),
    Expand = Table.ExpandTableColumn(Merge, "Test", {"StudentNumber"}, {"StudentNumberTakenBy"})
in
    Expand

 


Best regards from Germany
Manuel Bolz

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