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

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"