Forum Discussion

Pandadev's avatar
Pandadev
Post Prodigy
5 years ago
Solved

summarised table in query editor comma missing

Hi I have 75 tables which have the following columns matched taht I want to add a summarised table to in query editor.

The columns are QC Check and Researcher

Is it possible to create a table showing the QC Check and count of rows per researcher

 

i tried to research this but am getting an error saying comma missing  , plus some of the tables have spaces how would they be added , would it be in this format [my table]

= let
Source = Table.Combine({Table.SelectColumns(24_not_followed_by_ZZ, {"QC Check", "Researcher"}),
Table.SelectColumns(41_followed_by_Purchased, {"QC Check", "Researcher"}),
Table.SelectColumns(74_not_followed_by_ZZ, {"QC Check", "Researcher"}),
Table.SelectColumns(A3_Followed_by_99, {"QC Check", "Researcher"})}),

#"Removed Duplicates" = Table.Distinct(Source)
in

#"Removed Duplicates"

 

The output I was looking for

QC Checker                          Researcher  Rows

24 not followed by ZZ         DC               4

24 not followed by ZZ         BA               2

41 followed by Purchased   DC               9

41 followed by Purchased   RM              22

Need Help
  • edugoncalves's avatar
    edugoncalves
    5 years ago

    Hi Pandadev ,

    You're wrongly mentioning the tables, by default, it should be like this: #"Table_Name"

    With that in mind, you have the corrected code here:

    let
Source = Table.Combine({Table.SelectColumns(#"24_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"41_followed_by_Purchased", {"QC Check", "Researcher"}),
Table.SelectColumns(#"74_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"A3_Followed_by_99", {"QC Check", "Researcher"})}),

#"Removed Duplicates" = Table.Distinct(Source)
in

#"Removed Duplicates"

     

    Best Regards,

    Eduardo

3 Replies

  • edugoncalves's avatar
    edugoncalves
    Resolver I
    5 years ago

    Hi Pandadev ,

    You're wrongly mentioning the tables, by default, it should be like this: #"Table_Name"

    With that in mind, you have the corrected code here:

    let
Source = Table.Combine({Table.SelectColumns(#"24_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"41_followed_by_Purchased", {"QC Check", "Researcher"}),
Table.SelectColumns(#"74_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"A3_Followed_by_99", {"QC Check", "Researcher"})}),

#"Removed Duplicates" = Table.Distinct(Source)
in

#"Removed Duplicates"

     

    Best Regards,

    Eduardo

    • Pandadev's avatar
      Pandadev
      Post Prodigy
      5 years ago

      Thanks that worked , is there a way to just get the cound of Researcher

      like

      24 not followed by ZZ         DC               4

      24 not followed by ZZ         BA               2

      41 followed by Purchased   DC               3

      41 followed by Purchased   RM              2

       

      at the moment it is showing 

      24 not followed by ZZ         DC

      24 not followed by ZZ         DC

      24 not followed by ZZ         DC

      24 not followed by ZZ         DC

      24 not followed by ZZ         BA

      24 not followed by ZZ         BA

      41 followed by Purchased   DC

      41 followed by Purchased   DC

      41 followed by Purchased   DC

      41 followed by Purchased   RM

      41 followed by Purchased   RM

  • Pandadev's avatar
    Pandadev
    Post Prodigy
    5 years ago

    I managed to work it out myself thanks for your help on thie , I added 

    #"Grouped Rows" = Table.Group(Source, {"QC Check", "Researcher"}, {{"Rows", each Table.RowCount(_), Int64.Type}})
    in
    #"Grouped Rows"