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 showi...
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

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