E0f error

[Georgie_stanley]

Hi, how do I fix this error? 

let
Source = Json.Document(Web.Contents("https://dominowb.sharepoint.com/sites/WestonBeamor/Shared%20Documents/Plannerdata.json")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"taskid", "taskname", "task description", "taskprogress", "taskstart", "taskdue", "taskcomplete", "assignees", "subtasks", "buckets", "awaitingstones", "straighttocad", "xmas", "resinrequest", "missinginfo", "urgent", "awaitingengagementring", "cancelled", "sketch", "cadoutworker", "inunsetting", "inscanning"}, {"taskid", "taskname", "task description", "taskprogress", "taskstart", "taskdue", "taskcomplete", "assignees", "subtasks", "buckets", "awaitingstones", "straighttocad", "xmas", "resinrequest", "missinginfo", "urgent", "awaitingengagementring", "cancelled", "sketch", "cadoutworker", "inunsetting", "inscanning"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"taskid", type text}, {"taskname", type text}, {"task description", type text}, {"taskprogress", Int64.Type}, {"taskstart", type datetime}, {"taskdue", type datetime}, {"taskcomplete", type any}, {"assignees", type any}, {"subtasks", type any}, {"buckets", type any}, {"awaitingstones", type any}, {"straighttocad", type any}, {"xmas", type any}, {"resinrequest", type any}, {"missinginfo", type any}, {"urgent", type any}, {"awaitingengagementring", type any}, {"cancelled", type any}, {"sketch", type any}, {"cadoutworker", type any}, {"inunsetting", type any}, {"inscanning", type any}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"assignees", "subtasks"}),
#"Expanded buckets" = Table.ExpandListColumn(#"Removed Columns", "buckets"),
#"Expanded buckets1" = Table.ExpandRecordColumn(#"Expanded buckets", "buckets", {"bucketName"}, {"bucketName"}),
#"Removed Columns1" = Table.RemoveColumns(#"Expanded buckets1",{"taskcomplete", "taskstart"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns1",{{"taskdue", type date}}),
#"Added Conditional Column" = Table.AddColumn(#"Changed Type1", "Task Status", each if [taskprogress] = 0 then "Not Started" else if [taskprogress] = 50 then "In Progress" else if [taskprogress] = 100 then "Complete" else null),
#"Added Custom" = Table.AddColumn(#"Added Conditional Column", "Overdue", each if ([taskdue] <> null and [taskprogress] <> 100 and [taskdue] < DateTime.Date(DateTime.LocalNow()) ) then "true" else "false"),
#"Changed Type2" = Table.TransformColumnTypes(#"Added Custom",{{"Task Status", type text}, {"Overdue", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type2", each [taskid] <> null and [taskid] <> ""),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [taskname] <> null and [taskname] <> "")
in
#"Changed Type",
Output =
Table.View(
null,
[
GetType = () =>
type table [taskname = Text.Type],
GetRows = () =>
GetData(),
OnTake = (count as number) =>
if count=0
then
#table(type table [taskname = Text.Type], ()
else
GetData()
]
)/*,
BufferedOutput = Table.Buffer(Output)*/
in
//GetData()
Output
//BufferedOutput

[Anonymous]

Hi @shreebidwai 

It has the error in the following part.

in
#"Changed Type",
Output =
Table.View(
null,
[
GetType = () =>
type table [taskname = Text.Type],
GetRows = () =>
GetData(),
OnTake = (count as number) =>
if count=0
then
#table(type table [taskname = Text.Type], ()
else
GetData()
]
)/*,
BufferedOutput = Table.Buffer(Output)*/
in
//GetData()
Output
//BufferedOutput

In the 'in' part, you can only return to the steps in the let part. If you add other content after the 'changed type' in the 'in', it is not possible. You can treat this part as a step, just in the 'let' and finally return this step in the 'in'

e.g

let
output=....
in 
output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shreebidwai]

what is the error you are getting?

[Georgie_stanley]

The error comes up as Eo7 and it highlights the comma after #"Changed Type", 

[Georgie_stanley]

The error is here...

#"Changed Type",

It doesn't recognise the comma