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

Yes although im not quite sure how to enter the code.

 

Sincerely,

  • 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
      Responsive 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.