Beginner Power Query user with Grouped Rows Error

[OldCityCat]

Thanks to Bill Szysz at Excelguru for helping me with getting started with this porject.

After added the Grouped Rows line of code with my column name, I am getting a "Token Comma expeted" error when  show error

"tbl" is high lighted. I verified all column names a correct, not sure what else to look for.

Thank you in advance for any and all suggestions.

OldCityCat

let
    Source = Table.NestedJoin(RowOne,{"Employee_Num"},RowTwo,{"Employee_Num"},"RowTwo",JoinKind.LeftOuter),
    #"Expanded RowTwo" = Table.ExpandTableColumn(Source, "RowTwo", {"Name", "Employee_Num", "Code", "Date", "DailyAmount"}, {"RowTwo.Name", "RowTwo.Employee_Num", "RowTwo.Code", "RowTwo.Date", "RowTwo.DailyAmount"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Expanded RowTwo",{"Name", "Employee_Num", "Code", "Date", "Hours", "RowTwo.DailyAmount"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns", {"Employee_Num", "Date"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"RowTwo.DailyAmount", "DailyAmount"}}),
    #"Grouped Rows"= Table.Group(#"Renamed Columns", {"Employee_Num}, {{"tbl", each _ & Table.FromRecords({[#"Employee_Num"=null]}), type table [Name=text, Employee_Num=number, Code=text, Date=date, Hours=number, DailyAmount=number]}},0)
in
    #"Renamed Columns"

[artemus · Accepted solution]

Your missing a " at the end of"

"Employee_Num

[OldCityCat]

artemus,

Thanks for your reply, I guess I didn't see the forest for the trees.

After fixing the " and refreshing the query, I expected to see a new table with two columns

Employee_Num and tbl with a expand option. No such luck.

I still must be missing something.  

Any Ideas?

[artemus]

Seems to work fine for me.

Are you getting an error, or what are you seeing?

[OldCityCat]

I found my problem,

I needed to change  In to "#Rename Columns"

Work as expected 

#"Grouped Rows"= Table.Group(#"Renamed Columns", {"Employee_Num"}, {{"tbl", each _ & Table.FromRecords({[#"Employee_Num"=null]}), type table [Name=text, Employee_Num=number, Code=text, Date=date, Hours=number, DailyAmount=number]}},0)
in
    #"Renamed Columns"