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
TheNicholas27's avatar
TheNicholas27
New Member
2 years ago

Im trying but it gives me the error on the column name, even if i change the column name.

Im sorry, im no programmer therefore i don't understand where im going wrong.

 

let
Type = Table.TransformColumnTypes(Source,{{"Student district ID", Int64.Type}, {"Student Names", type text}, {"Student names having taken the test", type text}}),
Students = Type[[StudentNumber],[StudentName]],
Merge = Table.NestedJoin(Type, {"Student names having taken the test"}, Students, {"Student Names"}, "Test", JoinKind.LeftOuter),
Expand = Table.ExpandTableColumn(Merge, "Test", {"Student district ID"}, {"Student names having taken the test"})
in
Expand

  • ManuelBolz's avatar
    ManuelBolz
    Icon for Responsive Resident rankResponsive Resident
    2 years ago

    Hello TheNicholas27 

    okay, step by step... 

    Somewhere in Power Query you loaded the table that you showed as an example in your second post.

     

    Please share this M-Code with us so that we can add the correct solution.


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

    Best regards from Germany
    Manuel Bolz

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,
    Thanks for the solutions ManuelBolz  and dufoq3  provided, and i want to offer some more information for user to refer to.

    hello TheNicholas27 , you need to change your code to the following.

    let
Source=.....(your souce)
Type = Table.TransformColumnTypes(Source,{{"Student district ID", Int64.Type}, {"Student Names", type text}, {"Student names having taken the test", type text}}),
Merge = Table.NestedJoin(Type, {"Student names having taken the test"}, Type, {"Student Names"}, "Test", JoinKind.LeftOuter),
Expand = Table.ExpandTableColumn(Merge, "Test", {"Student district ID"}, {"Student district ID.1"})
in
Expand

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.