Nullable text?

[Tigerexcel]

Book3
	A	B
1	Position	Rep
2	HR	Jack
3	Sales	Fred
4	Finance	Jack
5	Admin	Pete
6	Mgt	Jack
7	Training	Fred
8	Security	Fred
9	IT	Jack
Sheet1

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Position", type text}, {"Rep", type text}}),
#"Grouped Rows" = #!"Table.Group(#""Changed Type"", {""Rep""}, {{""Count"", each [Rep], type list [Position=nullable text, Rep=nullable text]}})"
in
#"Grouped Rows"

Using PQ to return grouped by records, as in Jack HR, Finance, Mgt, IT
I get a Token comma expected message, I've tried inserting commas in various places but to no avail. When I remove the "[Position=nullable text, Rep=nullable text]" the command works and returns the grouped records.
What does the nullable text information come up as I haven't noticed it before? Where is the token comma supposed to go to make this work if I leave the nullable text info in?

 

[sandy666]

do you know how to use code tags?

 

[Tigerexcel]

Hi Sandy, not for PQ, I can't seem to activate them.

 

[sandy666]

maybe switch BB code to see options for code tags

 

[Tigerexcel]

How is this?

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Position", type text}, {"Rep", type text}}),
#"Grouped Rows" = #!"Table.Group(#""Changed Type"", {""Rep""}, {{""Count"", each [Rep], type list [Position=nullable text, Rep=nullable text]}})"
in
#"Grouped Rows"

 

[sandy666]

originally code from Advanced editor looks like

let
   Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
   #"Changed Type" = Table.TransformColumnTypes(Source,{{"Position", type text}, {"Rep", type text}}),
   #"Grouped Rows" = #!"Table.Group(#""Changed Type"", {""Rep""}, {{""Count"", each [Rep], type list [Position=nullable text, Rep=nullable text]}})"
in
   #"Grouped Rows"

 

[Tigerexcel]

originally code from Advanced editor looks like

let
   Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
   #"Changed Type" = Table.TransformColumnTypes(Source,{{"Position", type text}, {"Rep", type text}}),
   #"Grouped Rows" = #!"Table.Group(#""Changed Type"", {""Rep""}, {{""Count"", each [Rep], type list [Position=nullable text, Rep=nullable text]}})"
in
   #"Grouped Rows"

Yes, that's the same. I modified the M code to change from Table to List.

 

[sandy666]

there is a TAB before code line (step) as you can see and long lines are not wrapped in code tags
ok, now you know how to use code tags

 

[Tigerexcel]

Hi again Sandy et al, do I need to provide any more information to be able to solve this problem?

 

[sandy666]

Hi again Sandy et al, do I need to provide any more information to be able to solve this problem?

I know you are playing with the code but I don't understand what you want to achieve.
Any detailed description is welcome.